Alias: PFQD#

(P2K_PR_FREQUENCY_DETAILS)

Unique Keys:
Child Table: P2K_PR_FREQUENCIES
Parent Table:
ERD: ERD-PR05


Frequency Details

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PCT_IDNumber(10)IDYlink to P2K_PR_PAY_CATEGORIES
PFQ_IDNumber(10)IDYlink to P2K_PR_FREQUENCIES
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
TIMES_PER_YEARNumber(5)NUMBER5
EACH_PAYVarchar2(1)TOGGLE
ONCE_ONLYVarchar2(1)TOGGLE
FIRST_PAY_IN_PERIODVarchar2(1)TOGGLE
FIRST_PAY_IN_MONTHVarchar2(1)TOGGLE
PAY_IN_JANUARYVarchar2(1)TOGGLE
PAY_IN_FEBRUARYVarchar2(1)TOGGLE
PAY_IN_MARCHVarchar2(1)TOGGLE
PAY_IN_APRILVarchar2(1)TOGGLE
PAY_IN_MAYVarchar2(1)TOGGLE
PAY_IN_JUNEVarchar2(1)TOGGLE
PAY_IN_JULYVarchar2(1)TOGGLE
PAY_IN_AUGUSTVarchar2(1)TOGGLE
PAY_IN_SEPTEMBERVarchar2(1)TOGGLE
PAY_IN_OCTOBERVarchar2(1)TOGGLE
PAY_IN_NOVEMBERVarchar2(1)TOGGLE
PAY_IN_DECEMBERVarchar2(1)TOGGLE
PAY_1_OF_MONTHVarchar2(1)TOGGLE
PAY_2_OF_MONTHVarchar2(1)TOGGLE
PAY_3_OF_MONTHVarchar2(1)TOGGLE
PAY_4_OF_MONTHVarchar2(1)TOGGLE
PAY_5_OF_MONTHVarchar2(1)TOGGLE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page