System Parameters

Below are the system parameters available to Payroll Module. Consult Oracle Hospitality Cruise Customer Support prior to changing the Database Parameter to avoid any adverse implications.

Table 26-27 System Parameters

PAR Name PAR Value Description

Allow Closing of Pay Period Prior To End of Period

1 / 0

1= Allow program close pay period when pay period end date is greater than current PC date.

0= Do not allow to close pay period pay period end date is greater than current PC date.

Auto Close Balanced Posting When Close Pay Period

1 / 0

This is to avoid invoices from stacking up in Management module.

1= When close pay period Program automatically closes the posting for each crew member onboard invoice.

0= Do not close posting when close pay period.

Auto Close Pay Period After x Number of Days

 

Auto close pay period after x number of days system date change is run.

Base Wage Pay code For Corporate Instruction

 

Use by OHC DGS CMS.

Date Type

F / S

Determines whether Oracle date or SPMS system date is used for payroll calculations.

S= Oracle date.

F= SPMS system date (default).

Default Company Code

 

Value of PCY.PCY_CODE. Default company if there have multiple companies’ setup.

Default Payout

 

Value of SED.SED_NO. Default Payout code to display in the payout combo box on a new contract.

Default To 1 When Invalid Berth Number Is Entered

1 / 0

Value to select when editing a record in Edit Person function.

1= Default to 1 when no berth number is entered.

0= Prompt berth number is required.

Display UXP_C_EXTERNALID As Crew ID

1 / 0

ID display in Payroll Summary section.

0= UXP_C_INTERNALID.

1= UXP_C_EXTERNALID.

Early Period Open

A / Y / N

Determine whether to allow activation of pay period before current system date.

A= Always allow.

Y= Allow once.

N= Do not allow.

Edit Details Screen

1 / 0

0= Classic Screen.

1 – Quick reference screen

Folio Posting

Y / N

Y= Allow to post crew onboard expenses when payout.

N= Disallow (default).

GL Interface

Y / N

Y= Generate GL file after closing a pay period.

N= Do not generate GL File after closing a pay period.

Journal Id

 

The text used to identify payroll GL journals.

OceanPay File Output Folder

C:\temp

Path of folder for saving output files during generate card ordering for Cashless Payroll.

OceanPay MT Prefix Nbr

54

Defaults prefix number for MT Card. Populated in Cashless Payroll setup.

Exactly 30

Y / N

Change the way the number of days are calculated when changing positions in linked contract.

Y= If linked contract and contract is in middle of a month, then it will use 30 days instead of the number of days in the month to determine payment.

For example:

For 30 days in month:

- Contract 1 from 01/06/2008 - 10/06/2008 = 10 days

- Contract 2 from 11/06/2008 - 20/06/2008 = 10 days

- Contract 3 from 21/06/2008 - 28/09/2008 = 10 days

For 31 days in month:

- Contract 1 from 01/07/2008 - 10/07/2008 = 10 days

- Contract 2 from 11/07/2008 - 20/07/2008 = 10 days

- Contract 3 from 21/07/2008 - 28/09/2008 = 10 days (calculate as 10 days even date from 21/07/2008 to 31/07/2008)

N= Calculate based on number of day (31 days being paid since either contract end date or the contract start date fall in the pay period).

For example:

For 30 days in month:

- Contract 1 from 01/06/2008 - 10/06/2008 = 10 days

- Contract 2 from 11/06/2008 - 20/06/2008 = 10 days

- Contract 3 from 21/06/2008 - 28/09/2008 = 10 days

For 31 days in month:

- Contract 1 from 01/07/2008 - 10/07/2008 = 10 days

- Contract 2 from 11/07/2008 - 20/07/2008 = 10 days

- Contract 3 from 21/07/2008 - 28/09/2008 = 11 days (calculate as 10 days from 21/07/2008 to 31/07/2008)

Cash Advance To Disregard Onboard Expenses

1 / 0

1 – Cash advance available balance is not included onboard expenses.0 – Cash advance available balance is after deduct the onboard expenses.

Report ID For Onboard Expense

 

Onboard Expenses Report ID.

Report ID For SOE

 

Statement of Earnings Report ID.

Report ID For WRTS

 

Work / Rest Time Statement Report ID.

Return Bonus Pay code For Corporate Instruction

 

Use with DGS CMS.

Round Folio

Y / N

Y= Send only whole dollars for folio payoff until end of contract.

N= Send pennies to folio

Show Owner

Y / N

Y= Owner percent field appears on the crew contract form (For ResidenSea user).

N= Do not display (default)

Stock Code For OceanPay MT

 

Default Stock Code for MT Card. Populate in Cashless Payroll setup.

Tier 1 Percentage

 

To specify percent of Crew's First Tier Contribution. Used for Pension Plan to Employer Contribution.

Tier 2 Percentage

 

To specify percent of Crew's Second Tier Contribution. Used for Pension Plan to Employer Contribution.

To Disable Posting During Final Payout

1 / 0

1= Set UXP_A_POSTING = 0 during final payout.

0 =Allow crew posting after final payout

US Citizen TAX Pay code For Corporate Instruction

 

Use with DGS CMS.

Vacation Pay code For Corporate Instruction

 

Use with DGS CMS.

Cash Advance As Default Manual Payout

1 / 0

This parameter is OBSOLETED

Replace by pay code with calculation method – A-NBCP.

Ending Payroll Alert

1 / 0

To prompt Ending Payroll Notification.

Update BTD Total Upon System Date Change

1 / 0

1 – Enable ‘Update Total’ process when run system date change.

0 – Disabled

Cash Advance Disregards Onboard Expenses

1 / 0

1 – Enable to exclude onboard expenses into cash advance available amount

0 – Disabled

ByPass payout Settlement Integrity Check

1 / 0

1 -Allow to go through payout even difference between balance of Pay Addition and Pay Deduction

0 – Do not allow payout if balance of Pay Addition and Pay Deduction are different.

Default Pay Sheet Printing During Payout

1 / 0

1 - Default ‘Print Pay Sheet’ enabled in Payout screen0 - Default ‘Print Pay Sheet’ disabled in Payout screen.

Default Receipt Printing During Cash Advance

1 / 0

1 - Default ‘Print Receipt’ enabled in Cash Advance screen

0 - Default ‘Print Receipt ’ disabled in Cash Advance screen

Payout Crew member Even If Res Cancelled

1 / 0

1 – Allow cancelled reservation to do payout

0 – Do not allow cancelled reservation to do payout

The Month Where HSC-In-Excess Calculation Changes

YYYY-MM-DD

Specifies Any Day of The Month In Which HSC-In-Excess Calculation Changes.

Ignore Error Code In Fault Detection

 

Records With This Error Code Will Not Come Up In DGS-CMS-Related Fault Detection Screen.

Check All Payroll Paid Before Creating File

1 / 0

Check all payroll is being paid off before generate GL file.

1 – Enabled

0 – Disabled

Contract End Date Change Handling

1/2/3/4

Prompt Payroll Notification when change contract end date.

1=With Notification Removal, 2=Without Notification Removal, 3=User-Decide On Notification Removal, 4=Allow End Date Change Only On Date-Match.