Alias: PPP#

(P2K_PR_PAY_PERIODS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR20


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


Notes #

Click to create a new notes page