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.
...
Field | Description |
|---|---|
P1 | PIN |
P2a | Family Name |
P2b | Christian Name |
P2f | First Name |
P2m | Middle Name |
P2l | Last Name |
P2s | Name Suffix |
P2t | Title Name |
P3 | Address 1 |
P4 | Address 2 |
P5 | Postal Code |
P5c | Council code to post ZIP code |
P5y | Postal Code + Name |
P5e | If Post Code is blank, return Address3 |
P6 | Nationality Code |
P6a | Nationality Name |
P6b | Nationality Leave Time Factor |
P6y | Nationality Code+Name |
P6z | Nationality Code Group |
P7 | Home Telephone Number |
P8 | Sex: M/K/F |
P9 | Yrkesgruppe Department (previously P152 ) |
P9a | Department Name |
P9y | Department Code+Name |
P9z | Department Code Group |
P10 | Org unit NumorgId where person is linked to in Personal Details |
P10a | Org unit Name where person is linked to |
P10c | First Company Code |
P10y | Org unit No+Name |
P10d | Department Code |
P10e | Department Name |
P10f | Position Org Code |
P10g | Position Name |
P10h | Vessel Code |
P10i | Vessel Name |
P10m | Mother Company Org Code |
P10n | Mother Company Name |
P10o | Mother Company Org Nr ID |
P11 | Category A |
P11a | Category A Name |
P12 | Category B |
P13 | Category C |
P14h P14a | Person Id No |
P15 P15d | Employment Start Date Employment Start Date in format yyyymmdd |
P15f | Days employed to today |
P15g | Days employed to the end of period |
P15e | Employement Start date in real date value |
P16 | Employment End Date |
P16e | Employment End date in real date value |
P17 | Comments |
P18 | Rank Code |
P18a | Rank Name |
P18s | Rank Code Specification |
P18x | Rank Category |
P18y | Rank Code + Name |
P18z | Rank Group No. |
...
P23s |
...
Code A | |
P23a | Text |
P23z | 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 |
...
Percentage NO/FI | |
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 |
...
Position Fraction |
...
P128 | Mobile Phone No |
P157 |
...
Division | |
P223 |
...
User name last updated record | |
P224 |
...
Time for last updated record ("yymmddttmm") | |
P154 |
...
Marital Status Code TRANSFERRED TO P101 |
...
P102 |
...
Relationship Next of Kin |
...
P103 |
...
Name Next of Kin |
...
P104 |
...
Address Next of Kin |
...
P105 |
...
Text special date | |
P106 |
...
Home Airport | |
P107 |
...
Picture no | |
P108 |
...
Family comments |
...
P109 |
...
Visa, No |
...
P110 |
...
Visa, Expiry Date | |
P111 | Passport, No |
P112 | Passport, Date of Issue |
P113 | Passport, Place of Issue |
...
P114 | Passport, 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 |
...
P159 | Finnish Tax Type ('A' for ALLMÄN, ‘B' for BEGRÄNSAD, 'K’ for KÄLLSKATT |
P187 | Seaman's Book, Number |
P188 | Seaman's Book, Issued By |
P189 | Seaman's Book, Expiry Date |
P190 | Contract Expiry Date |
P196 | Contract start date (dd/mm/yyyy) |
P251- |
...
P270 | 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 |
...
Monthly Deduction For Tax At Source (FI tax) | |
P284 | Akk 34 |
P100 | Address 3 |
P100d | Address 3, or Blank |
P142 | Person Leave Days Factor |
P142a | Leave Days Factor from 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 |
...
Perio | |
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 Until: (From V2.31) |
P260 | Person Region Code |
P260y | Company Region Code + Region Detail |
P261 | Distinct Number of History periods in the |
...
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 curr |
P270 | d Last date (in real date value) of the |
...
la | |
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) |
P367 | Income-based Pension Scheme ( Payroll | Constants) |
P293 | Lifeboat Instruction |
P301 | Current Promotion Rank Seniority |
...
P302 | Returns number of weeks worked per activity, inside a payroll period. A week is not count twice if there are 2 activities in the same week. A week is not count if Monday of that week started in the previous month. If a person gets 65 years old inside period - weeks are count only before 65 years. Related activity should belong under vessel where flag ='MT'. If the Datefrom of payroll entry = First date of the week, then this week is count. If Datefrom starts in a middle-week, then check if exists any other auto entry in the current period which covers the week, if yes, then not count the week this time. If it doesn't exist such auto entry, then count the week. |
P303 | Alternative Address line 1 |
P304 | Alternative Address line 2 |
P305 | Alternative Address line 3 |
P306 | Alternative Address Country |
P307 | Alternative Address ZIP/Place |
P308 | Port Sign On |
P309 | Port Sign Off |
P311 | Marital Status for tax |
P312 | Exempt from income tax (Y/N) |
P313 |
...
Additional Tax Amount | |
P315 | 401(K) - Pre Tax |
P316 | 401(K) -Post Tax |
P317 | 401(K) -PreTax Catch Up |
P318 | 401(K) -Roth |
P319 | Last activity vessel in current period |
P319a | Name of the last vessel in current period |
P320 | NUMORGID of the vessel from Current activity (or latest historical when no current) but only if activity linked to department or position |
P320a | Name of the vessel from Current activity (or latest historical when no current) but only if activity linked to department or position |
P321 | Department’s Org. ID from Current activity (or latest historical when no current) |
P321a | Name of the department from Current activity (or latest historical when no current) |
P321b | Department’s Org.Code from Current activity (or latest historical when no current) |
P322a | The vessel from last activity in current payroll period. Activity can be Planned, Historical or Current. If there is no activity in current period, then the vessel will be fetched from previous period. |
P323 | Table of Person |
...
P338 | Shift Code |
P499 | Person Age dynamic value |
P500 | Average number of children for all active persons on all ships in the company |
P501 | Leave 1 Balance pr leave balance date in previous period. If it is blank,pr. den 1. i current period(from calendar,or from period register). |
P502 | Leave 1 Balance pr. leave balance date in current period. If it is blank, den 31. i current period (evt. 28. eller 30., from calendar, or from period register). |
...
Note: Days "settled via payroll" for current payroll period are not included. | |
P503 | Leave 2 Balance pr. leave balance date in previous period. If it is blank,pr. den 1. i current period (from calendar,or from period register). |
P504 | Leave 2 Balance pr. leave balance date in current period. If it is blank, den 31. i current period (evt. 28. eller 30., from calendar,or from period register). |
P505 | Leave 1 days within Leave balance date in previous period to the current period, if leave balance date is blank, get the period from calendar. |
P506 | Leave 2 days within Leave balance date in previous period to the current period, if leave balance date is blank, get the period from calendar. |
P507 | Leave days balance per today |
P600 | To Date from Activity from current period |
P600d |
...
To Date from Activity på current periode in real date value | |
P601 | Payroll last date for current period |
P601d | Payroll last date for current period in real date value |
P602 | Is today payroll day ? "Y"/"N" |
P603 | Startdate of current period |
P603a | Startdate of current period in YYYYMMDD |
P603d | StartDate of current period - in days |
P604 | Enddate of current period |
P604a | Enddate of current period in YYYYMMDD |
P604d | EndDate of current period - in days |
P610 | Advance Payment Date for current period |
P610d |
...
Advance Payment Date på current peridoe in real date value | |
P401-P410 | Person User defined Field 1-10 |
P411 | Person Payroll Period First date (in real date value) from period register |
P411a |
...
Last date before P411 in real date value | |
P411b |
...
Leave days balance date in the last period in real date value | |
P411c |
...
Next day of P411c in the last period in real date value | |
P411e |
...
Person period First day in format YYYYMMDD | |
P411f |
...
Last date before P411 in format YYYYMMDD | |
P411g |
...
Leave days balance date in the last period in format YYYYMMDD | |
P411h |
...
Next day of P411c in the last period in format YYYYMMDD | |
P412 | Person Payroll period Last date (in real date value) from period register |
P412a |
...
Last date before P412 in real date value | |
P412b |
...
Leave days balance date in the current period in real date value | |
P412e |
...
Person period last day in format YYYYMMDD | |
P412f |
...
Last date before P412 in format YYYYMMDD | |
P412g |
...
Leave days balance date in the current period in format YYYYMMDD | |
P413 | Actual days in period |
P415 | First Saturday in current period (Windows date format) |
P415e | First Saturday in current period (real date format) |
P701 | Total Activity Days for Activity Group 1 in the current payroll year |
P701p | Total Activity Days for Activity Group 1 in the PREVIOUS payroll year |
P702 | Total Activity Days for Activity Group 2 in the current payroll year |
P702p | Total Activity Days for Activity Group 2 in the PREVIOUS payroll year |
P710 | Total Activity Days for Activity Group 10 in the current payroll year |
P710p | Total Activity Days for Activity Group 10 in the PREVIOUS payroll year |
P990 | Date of today (default format) |
P990d | Date of today in real date format |
P990e |
...
Today in format YYYYMMDD | |
P991d |
...
Payment date of current period in real date value | |
P991e |
...
Payment date of current period in format YYYYMMDD |
Available field nrs:
P271- P314-P322 P328-362 P368-P400 P413-P498 P507-P599 P603- P609 P610- 699 711- 989 991
...
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 | 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 | 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 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 |
H259 | Indicating real sign off on the same vessel. H259a: in YYYYMMDD format |
H260 | Indicating Date to or Estimated end date of last historical (HISTORICAL.PW001P03=T) activity. H260a : in YYYYMMDD format |
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; |
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 |
...