GPHK_I56_QT_AET

(SQL Table)
Index Back

Temporary Table for IR56 Prcs

This table is used by IR56 creation process. It is used for storing quarters information that is used by the process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 GPHK_QTR_NUM Number(2,0) SMALLINT NOT NULL A running serial number to allow users to enter multiple quarters information for a single employee.
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 GPHK_PRD_BGN_DT Date(10) DATE The Begin date is required for the purpose of reporting.
7 GPHK_PRD_END_DT Date(10) DATE The End date is required for the purpose of reporting.