GPGB_TEST_SRCH

(SQL View)
Index Back

Payee Segment Status

Payee Segment Status

SELECT c.EMPLID , C.CAL_RUN_ID , C.EMPL_RCD , C.GP_PAYGROUP , C.CAL_ID , C.RSLT_SEG_NUM FROM PS_GP_PYE_SEG_STAT C WHERE C.CALC_ACTION = 'C'

# 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 Record
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 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number