P 2 K_PR_PAY_PERIODS
Back to current versionRestore this version

Alias: PPP#

Unique Keys: _
Child Table:
_
Parent Table: _

Pay Periods

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PCL_IDNumber(10)IDYlink to P2K_PR_PAY_CALENDARS
PAY_PERIODNumber(10)NUMBER10Y
WEEK_END_DATEDate()DATEY
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
PAY_PERIOD_START_DATEDate()DATE
PAY_PERIOD_END_DATEDate()DATE
PAY_ISSUE_DATEDate()DATE
ADVANCE_DATEDate()DATE
PAY_OF_MONTHNumber(5)NUMBER5
PAY_OF_YEARNumber(5)NUMBER5

User Fields: Allowed
Audit Logging: Allowed