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.

...

Field

Description

L1

PIN

L2

Seq No

L3

Source ("S" - Payroll Module Auto Entry, <blank> Payroll Module manual entry,

"T" - Timecard module, "E" - from another Entry code, "I" - from APP, “G” - Gratuities plugin)

L4

From Vessel

L5

Changed By

L6

Create Time

L7

Changed By

L8

Change Time

L9

Calculated By

L10

Calculate Time

L11

Is Back Pay Entry (Y/N)

L15

From Period

L16

To Period

L17

Reference (Ref)

L18

Entry Code number

L18a

Entry Code text

L19

L19a

L19d

From Date

From Date (yyyymmdd)

From Date (nr of days)

L20

L20a

L20d

To Date

To Date (yyyymmdd)

To Date (nr of days)

L21

Entry Field [1]

L22

Entry Field [2]

L22a

With Hours Sign ON/ OFF

L22d

Activity Leave days in current period

L22h

Holiday counter in current period

L22w

Business Days counter of activity in current period

L22y

Activity days in current period

L23

Entry Field [3]

L24

Entry Field [4]

L25

Entry Field [5]

L26

Entry Field [6]

L30

Category Code

L30a

Category Name

L31

AccountNo Dim [1]

L32

Account Dim [2]

L33

Account Dim [3]

L34

Account Dim [4]

L35

Account Dim [5]

L36

Account Dim [6]

L37

LTO Ref

L38

Info PAYNAME

L47

Account Dim [7]

L48

Account Dim [8]

L49

Account Dim [9]

L40

Account Dim [10]

L41

Account Dim [11]

L42

Account Dim [12]

L43

Contract PW001P20.SEQUENCENO

L50

Period Used

L50a

Period within year (Period Used mod 100)

L51

Credit Entry

L52

Currency Code for calculation

L53

Currency Code

L54

Currency rate for calculation

L55

Currency Rate

L56

Current Currency

L57

Calculation Priority

L58

Department

L59

County No

L61

Calculated Amount 1

L62

Calculated Amount 2

L63

Calculated Amount 3

L64

Calculated Amount 4

L65

Calculated Amount 5

L66

Calculated Amount 6

L67

Calculated Amount 7

L68

Calculated Amount 8

L69

Calculated Amount 9

L70

Calculated Amount 10

L71

Calculated Amount 11

L72

Payscale Table

L73

Payscale Code

L74

Seniority Year

L78a

Payroll Seniority years at Payroll period Start

L78b

Payroll Seniority months at Payroll period Start

L78c

Payroll Seniority days at Payroll period Start

L79a

Payroll Seniority years at Payroll period end

L79b

Payroll Seniority months at Payroll period end

L79c

Payroll Seniority days at Payroll period end

L80

Rank

L80a

Rank name

L80y

Rank code + name

L80z

Rank group No

L80s

Rank code specification

L81a

Org code of the first company over Accdim2

L81b

Name of the first company over Accdim2

L81c

Numorgid of the first company over Accdim2

L83

Currency Code for Payment

L84

Currency Rate for Payment

L85

Real SignOn date (sea service activity)

L85: in the same date format as selected on the computer;

L85a: In the format YYYYMMDD;

L85d: In the real data format;

L85h: P03.SONTIME hour value;

L86

Date from of activity (sea service activity)

L86a

Date from of activity (sea service activity) in format YYYYMMDD

L86d

Date from of activity (sea service activity) in real data format

L86n

Date from of activity (regardless limitation of sea service option) in format YYYYMMDD

L86m

Date from of activity (regardless limitation of sea service option) in real data format

L87

Real days onboard up to end of current period (sea service activity)

L88

Employer fee rate

L89

Count of period for this entry code in this year

L90b

Leave days balance B/F of auto payroll entry

L90c

Leave days balance C/F of auto payroll entry

L91

Giving number of Sundays in the activity period within the current period.

L92

Giving number of Saturdays in the activity period within the current period.

L93

Giving number of holidays in the activity period within the current period.

L93a

Giving number of holidays in the activity period within the current period, excluding Sundays (if it corresponds to a holiday)

L93b

Returns the number of Public Holidays excluding Saturdays

L93c

Returns the number of Public Holidays excluding Saturdays and Sundays

L93t

Number of weekend days + holidays in the payroll period. The days are calculated based on the calendar linked to the person's payscale. If no link exists, the calendar in the person's client (organization) will be used.

L94

Giving number of Monday in the activity period within the current period.

L96

First two characters of vessel location name for a auto entry (split by vessel location)

L96a

Vessel location code for a auto entry (split by vessel location)

L97

Auto Entry (Y/N)

L98

Balance action of additional info

L99

Leave days of activity on Fromdate and Todate of payroll entry

L100

Returns the number of Mondays for current period

L101

Quantity1

L102

Quantity2

L103 

Returns number of weeks worked per activity, inside a payroll period.

Calculation rules:
1) A week is not count twice if there are 2 activities in the same week.
2) If a person gets 65 years old inside period - weeks are count only before 65 years.
3) Related activity should belong under vessel where flag ='MT'. 
4) Week should be counted when at least one day covered(doesn`t matter in the middle of the week or not) if this week was not counted earlier. For example in previous period or with other auto-entry in current period.(APM-4374)

L104

Returns number of weeks worked per activity, inside a payroll period.

Calculation rules:

  1. It returns number of weeks worked per activity, inside a payroll period.

  2. A week is not count twice if there are 2 activities in the same week.

  3. A week is not count if Monday of that week started in the previous month.

  4. If a person gets 65 years old inside period - weeks are count only before 65 years.

  5. If the Datefrom of payroll entry = First date of the week, then this week is count.

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

  7. For weeks after the first week, payroll entry will count each Monday it covers.

  8. For the first week of period, if an entry with DateFrom middle in this week, this week is NOT count;

L107

Counts all the holidays (from Monday to Friday) between the FromDate and ToDate of the payroll entry.

L107a

Locates all the weeks that intersect the FromDate - ToDate of the payroll entry, and counts all the holidays (from Monday to Friday) within those weeks.

L111

Account No of calculated Amount 1

L112

Account No of calculated Amount 2

L113

Account No of calculated Amount 3

L114

Account No of calculated Amount 4

L115

Account No of calculated Amount 5

L116

Account No of calculated Amount 6

L117

Account No of calculated Amount 7

L118

Account No of calculated Amount 8

L119

Account No of calculated Amount 9

L120

Account No of calculated Amount 10

L121

Account No of calculated Amount 11

L131

Flag of calculated amount 1

L132

Flag of calculated amount 2

L133

Flag of calculated amount 3

L134

Flag of calculated amount 4

L135

Flag of calculated amount 5

L136

Flag of calculated amount 6

L137

Flag of calculated amount 7

L138

Flag of calculated amount 8

L139

Flag of calculated amount 9

L140

Flag of calculated amount 10

L141

Flag of calculated amount 11

L151

Account No of calculated amount credit 1

L152

Account No of calculated amount credit 2

L153

Account No of calculated amount credit 3

L154

Account No of calculated amount credit 4

L155

Account No of calculated amount credit 5

L156

Account No of calculated amount credit 6

L157

Account No of calculated amount credit 7

L158

Account No of calculated amount credit 8

L159

Account No of calculated amount credit 9

L160

Account No of calculated amount credit 10

L161

Account No of calculated amount credit 11

L162

Activity Code (overwritten input of activity code by validity check)

L163

Activity date to --In current Windows format (string)

L163d

Activity date to -- in days

L164

Indicating real sign off date on the same vessel. If no DateTo, then fetch EED. (works with Current and Historical activities)

L164: in the same date format as selected on the computer;

L164a: in YYYYMMDD format;
L164e: in real date format;
L164d: in real date format;
L164h: P03.SOFFTIME hour value;

L165

Indicating real sign off date regardless of the vessel. If no DateTo, then fetch EED. (works with Current and Historical activities)

L165: in the same date format as selected on the computer;

L165a: in YYYYMMDD format
L165d: in real date format with 2 decimals
L165e: in real date format with 8 decimals
L165h: P03.SOFFTIME hour value;

L166

Date to or Estimated end date of last historical payroll entry.

L166: in the same date format as selected on the computer;

L166a : in YYYYMMDD format;
L166e: in real date format;

L167

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

L167: in the same date format as selected on the computer;

L167a : in YYYYMMDD format;
L167e: in real date format;
L167h: P03.SOFFTIME hour value;

L168

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

L168: in the same date format as selected on the computer;

L168a : in YYYYMMDD format;
L168e: in real date format;
L168h: P03.SOFFTIME hour value;

L169

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

L169: in the same date format as selected on the computer;
L169a: in YYYYMMDD format;
L169e: in a real date format;
L169h: P03.SOFFTIME hour value;

L178a

Seaservice Seniority years at Payroll period Start

L178b

Seaservice Seniority months at Payroll period Start

L178c

Seaservice Seniority days at Payroll period Start

L179a

Seaservice Seniority years at Payroll period end

L179b

Seaservice Seniority months at Payroll period end

L179c

Seaservice Seniority days at Payroll period end

L180

Allowance or Deduction? 'A' or 'D'

L181

Last activity vessel in current period under the employer of entry record.

L182

to fetch Sign On extra days from pw001p01

L183

to fetch Sign Off extra days from pw001p01

L185

to fetch Payroll additional info, bank account nr

L186

to fetch the Plan rate of Benefit record covering current period for a person

L187

Payment bank ID

L187a

Payment bank account No.

L187b

Payment bank code

L187c

Payment bank currency code

L191 - L195

Return number of weekday calendar days that are not public holidays in the activity period within the current payroll period.

L191 – for number of Mondays

L192 - for number of Tuesdays

L193 - for number of Wednesdays

L194 - for number of Thursdays

L195 - for number of Fridays

L196

Returns the Holiday Name, if the payroll entry’s FromDate (L19) corresponds to a holiday from a calendar linked to the entry Payscale Table/Code

L991

Numorgid of employer of pw001p01.client.

L992

Numorgid of employer above vessel in (DIM2) and

L990

the field employer of entry (PAY or PYH), default is L991

L1101

Calculated Amount 1 used for back pay

L1102

Calculated Amount 2 used for back pay

L1103

Calculated Amount 3 used for back pay

L1104

Calculated Amount 4 used for back pay

L1105

Calculated Amount 5 used for back pay

L1106

Calculated Amount 6 used for back pay

L1107

Calculated Amount 7 used for back pay

L1108

Calculated Amount 8 used for back pay

L1109

Calculated Amount 9 used for back pay

L1110

Calculated Amount 10 used for back pay

L1111

Calculated Amount 11 used for back pay

PR

(PR1, PR2 etc) - Personal Rate

X

Xn (X1, X2 etc) - Payscale Rate

XA

XAn (XA1) - Payscale Rate column A

XB

XBn (XB1) - Payscale Rate column B etc.

Xs

Xns (X1s, X2s) - Payscale Rate by sea-service seniority

...

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 return count of pre-holiday days based on dates of 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

...