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.
...
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 |
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 |
...
Field Name | Description |
---|---|
C21 | Contract ID |
C22 | Contract kind (MAIN, SUB, AMENDMENT) |
C23 | Contract start date |
C24 | Contract end date |
C25 | Payroll seniority start date |
C26 | Payroll seniority end date |
C27 | Payroll seniority prev years |
C28 | Payroll seniority up to this period |
C29 | Sea service seniority start date |
C30 | Sea service seniority end date |
C31 | Sea service seniority prev years |
C32 | Sea service seniority up to this period |
C33 | Contract payscale table |
C34 | Contract payscale code |
С35 | Contract type: code + name |
С35a | Contract type: code |
CRn | CR => Contract Personal Rates n => identifies the rate number RATENO in the contract |
C36 | Real End Date for the Contract. Means if Main contract has Amendment and even few Amendments, For Sub Contracts this field will just fetch it`s End Date. |
C37 | Payroll Vessel in Contract |
C38 | Contract Rank Code *added from APM 2024.30 |
Note: All date fields can have suffix: a : YYYYMMDD format d : Real date format |
...