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.

...

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
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

...

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
personal rates table. The rate nr is defined in the general code
table defining the rate fields.

C36

Real End Date for the Contract.

Means if Main contract has Amendment and even few Amendments,
this field will fetch the End Date of the last Amendment related to the
Main Contract.

For Sub Contracts this field will just fetch it`s End Date.

C37

Payroll Vessel in Contract
*added from APM 2023.40.2.1

C38

Contract Rank Code

*added from APM 2024.30

Note: All date fields can have suffix:

a : YYYYMMDD format

d : Real date format

...