Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

There are several fields from the record in payroll, that can be used or set in FAQ Payroll Script. Below is an overview of all these fields.

...


P301 Current Promotion Rank Seniority
P23 Payscales Code A
P23a Payscale Text
P23z Payscale Code - Sort Code
P28 Seniority Start Date
P28a Sea Service Seniority Start date
P33 Automatic Pay Rise Code
P38 Comments
P46a Leave Pay Accounting Factor
P213 Period lock for payroll
P48 Pay Slip Layout No
P49 Comments
P50 Tax Region No
P50a Company Region Code
P50b Company Region Tax Zone
P50c Company Rate for region, after year 2007 P50c=P50d from Company Rate 90 if equal to a1 check Global rate 1 = 14,1%
P50d New Company Rate for region
P50y Company Region Code + Region Detail
P54 Tax Table NO
P55 Tax % NO
P58 Seaman's Deduction: N/Y
P60 transfer balance (balance action)
P61 Bank Account No
P63 Personal Account No
P47 Currency Code
P69 Alternative LTO-code
P197 Person Group
P143 Options for Wages table
P101 Marital Status Code
P62 Days Employed This Year
P73 Additional Accounting Information
P75 Default relief (PIN)
P85 ADDRESS_COUNTRY
P86 Contract Type: String10, code + name
P86a Contract Type Code
P87 Seniority End Date
P87a Sea Service Seniority End Date
P93 AutoTax : Byte (0: None, 1: Norwegian)
P94 TaxExemption (0: Full Deduction, 1:Half, 2:No)
P95 TaxComment:String100
P172 Pre-earned Payroll Seniority Years
P172a  Pre-earned Sea Service Seniority Years
P198 549 6 0R Position Fraction
P23 579 14 0P Payscales Code A
P128 649 15 0U Mobile Phone No
P157 664 2 10 Division
P223 666 6 0U User name last updated record
P224 672 4 26 Time for last updated record ("yymmddttmm")
P154 701 2 804 Marital Status Code TRANSFERRED TO P101
*P102 703 2 907 Relationship Next of Kin
*P103 705 25 0U Name Next of Kin
*P104 730 50 0U Address Next of Kin
*P105 780 15 0U Text special date
P106 795 20 0U Home Airport
P107 815 4 20 Picture no
P108 819 20 0U Family comments
*P109 839 20 0U Visa, No
*P110 859 4 25 Visa, Expiry Date
P111 Passport, No
P112 Passport, Date of Issue
P113 Passport, Place of Issue
P114Passport, Authority of Issue
P115 Passport, Date of Expiry
P118 Height
P119 Weight
P120 Passport Comments
P132 Place of Birth
P133 Date of Death
P144 Date of Birth
P144a Age in years
P144d Date of Birth in days
P144f Date of Birth (YYYYMMDD format)
P147 Union Code
P14 Personal Id No
P187 Seaman's Book, Number
P188 Seaman's Book, Issued By
P189 Seaman's Book, Expiry Date
P190 Contract Expiry Date

P251-270 Accumulators of this period, akk 21-40
P271 Akk 21
P272 Akk 22
P273 Akk 23
P274 Akk 24
P275 Akk 25
P276 Akk 26
P277 Akk 27
P278 Akk 28
P279 Akk 29
P280 Akk 30
P281 Akk 31
P282 Akk 32
P283 Akk 33
P284 Akk 34

P100 Address 3
P100d Address 3, or Blank
P142 Person Leave Days Factor
P142a Leave Days Factor from payscale override
P148 Airport travel time

P213 Period lock for payroll
P226 Payroll Status
P227 Payroll Type
P228 Crew Pool
P229 Employment Seniority Years
P230 Alternative AS Code
P231 Onboard Days in the current payroll year
P231p Onboard Days in the PREVIOUS payroll year
P231c Onboard Days in the current period
P232 Leave Days Balance for the last date of previous payroll month (fetched from the Leave Days Accumulator set on company period)
P232c Leave Days Balance for the last date of current payroll month (fetched from the Leave Days Accumulator set on company period)
P236 Working Spouse (Y/N)
P237 No of Dependants:
P238 Rotation
P239 Shift Start
P240 Shift Vessel
P241 Currency Payment
P242 Cost Place
P243 PayBankNo
P245 SRC Nummer
P246 Leave Days Deducted Factor
P247 Allowances Claimed
P248 PayrollVessel
P248a PayrollVessel Name
P248c First Company Org code over Payroll Vessel
P248f PayrollVessel Short Name
P248g PayrollVessel Org Code
P248y PayrollVessel NumOrgId ":" Name
P249 TaxInfo
P250 Tax Code for UK Tax
P251 Month Week Basis for UK Tax
P252 Payroll Seniority Years Per Current Period
P252a Payroll Seniority Years Per Current Period Without include Pre Year Seniority
P252s Payroll Seniority Years Per Sea service
P253 NI Number
P254 UK PayRate
P255 UK PayCategory
P256 Tax Code Number (UK)
P257 Num Period (UK)
P258 Period No (UK)
P259 Use Current Payscale Until: (From V2.31)

P260 Person Region Code
P260y Company Region Code + Region Detail
P261 Distinct Number of History periods in the year
P264 Payroll Vessel Cost Group Code.
P265 US Tax ITIN
P266 US Tax SSN
P267 LEAVEPAY_DEDUC_FACT1
P268 LEAVEPAY_DEDUC_FACT2
P269 First day of the first activity in the current period
P269d First date (in real date value) of the first activity in the current period

P270 Last day of the last activity in the current period, if it is a opened activity and activity payscale with option "", it return the day of estimated enddate
P270d Last date (in real date value) of the last activity in the current period
P271 Last day of the current period
P271d Last date (in real date value) of the current period

P272 Transaction Type (Alternantive receiver)
P273 PHONE (Alternative receiver)
P274 GENDER (Alternative receiver)
P275 BRANCHNAME (Alternative receiver)
P276 BIRTHDATE (Alternative receiver)
P280 Tax Card TYpe
P281 Tax Card Date

P282 TAXPERCENTAGEEXTRA
P283 MONTHLYDEDUCTION
P284 COMPENSATION
P285 Address_Country (Alternative Address in Other folder in PD)

P293 Lifeboat Instruction

P363 ACC63 for the UK Tax year initial (Period 03)
P364 ACC64 for the UK Tax year initial (Period 03)

...

H0

Data Group Type (=3 for activities)

H1

Activity Code

H1a

Code Text

H1y

Code + Text

H1c

Code Group

H2

Code Group

H3

Date From

H4

Date To

H5

Date From

H6

Date To

H7

Date To

H30

Number of days

H31

Leave days

H31a

Leave days in current period

H31g

Leave Days with 2 decimals only

H32

Place from

H33

Place to

H34

Vessel No

H34a

Vessel Name

H34b

First Company's name

H34c

First Company's Org code

H34d

First Department's Org code

H34e

First Department's name

H34f

First Position's Org code

H34g

Position's name

H34j

Position's Org code without colon and number

H34y

First Vessel's Org nummer ID + Name

H35

Rank

H35a

Rank Name

H35b

Payscale for the Rank

H35c

Leave Factor for the Rank

H35p

Activity Rank category from Position

H35x

Activity Rank category

H35y

Rank Code + Name

H35z

Code Group for the Rank

H36

Comments

H37

Relief

H38

Payscale Code

H39

Gammel båtkode, konvertert fra PERMA

H54a

Company accounting code

H54b

Vessel accounting code

H54c

Department accounting code

H54d

Position accounting code

H95

Returns number of Monday for the whole activity

H95s

Number of Sundays in the activity

H96

Number of holidays for an activity based on its payscale calendar

H97

Number of Saturdays in the activity

H131

Flag Code

H132

Vessel Type

H133

Vessel Tonnage

H134

Vessel Engine Type

H135

Vessel Operator

H136

Planned

H137

Seniority

H138

Estimated End date

H142

Department code for activity. Returns department even if activity is linked to a position below department

H151

Additional field1 in Activity

H152

Additional field2 in Activity

H153

Additional field in Activity

H154

Additional field4 in Activity

H155

Additional field5 in Activity

H156

Additional field6 in Activity

H157

Additional field7 in Activity

H158

Additional field8 in Activity

H159

Additional field9 in Activity

H160

Additional field10 in Activity

H161

Additional field11 in Activity

H162

Additional field12 in Activity

H163

Additional field13 in Activity

H164

Additional field14 in Activity

H165

Additional field15 in Activity

H166

Additional field16 in Activity

H167

Additional field17 in Activity

H168

Additional field18 in Activity

H169

Additional field19 in Activity

H170

Additional field20 in Activity

H239

Project Code

H239a

Project Name

H239b

Project Code + Name

H238

Cost Place

H237

Cost Group

H337

Activity Class

H234

Markup Amount

H235

Markup %

H236

Management Fee

H256

The field that returns count of pre-holiday days based on dates of activity

H256c

This field returns count of pre-holiday days during Current Payroll Period based on the dates of the activity.

H257

Returns Sign Off date (Sea service activity) before the leave activity

H258

Indicating real sign off date regardless of the vessel.

H258a: in YYYYMMDD format
H258d: in real date format with 2 decimals (If no date to, then fetch Estimated date)
H258e: in real date format with 8 decimals (If no date to, then fetch Estimated date)

H259

Indicating real sign off on the same vessel.

H259a: in YYYYMMDD format
H259d: in real date format with 2 decimals (If no date to, then fetch Estimated date)
H259e: in real date format with 2 decimals (If no date to, then fetch Estimated date)

H260

Indicating Date to or Estimated end date of last historical (HISTORICAL.PW001P03=T) activity.

H260a : in YYYYMMDD format
H260e: in real date format with 2 decimals (If no date to, then fetch Estimated date)

H261

Indicating real sign off date on the same vessel (for open activity also);

H261a: in YYYYMMDD format

H261e: in real date format with 2 decimals (If no date to, then fetch EED)

H262

Indicating real sign off date regardless of the vessel (for open activity also)

H262a: in YYYYMMDD format

H262e: in real date format with 2 decimals (If no date to, then fetch EED)

H263

Indicating real sign off date by employer(if DateTo empty, EED will be used)

H263: in the same date format as selected on the computer;
H263a: in YYYYMMDD format;
H263e: in a real date format;

H298

Extra Activity Sign On Code

H298a

Extra Activity Sign On Text

H299

Extra Activity Sign Off Code

H299a

Extra Activity Sign Off Text

H330

PayScale Table

H336

Pension fund Class

H338

Vessel Cost Group

H339

Vessel Cost Place

H333

Status

H430

Person Notified

H431

Competence Checked

H432

Manning agent Informed

H433

Master Informed

H434

Crew Change Completed

H248

Sign On Extra Days (from activity details)

H249

Sign Off Extra Days (from activity details)

H466

Disembarkation Reason Code

...