GP_PYE_RUN_SEG

(SQL Table)
Index Back

GP Payee Run Segment

The GP Payee Run Segment table is the most detailed level child table for Payee Calendar Run Overrides.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 SEG_BGN_DT Date(10) DATE NOT NULL Payee Process Segment's Begin Date
7 SEG_END_DT Date(10) DATE NOT NULL Payee Process Segment's End Date
8 PRC_IND Character(1) VARCHAR2(1) NOT NULL Process Indicator. 'Y' = Yes, 'N' = No.

Y/N Table Edit

Default Value: Y