GPCH_OT_SS_VW

(SQL View)
Index Back

GP CHE Overtime SS view

Self Service Overtime

SELECT P.EMPLID ,O.OPRID ,P.EMPL_RCD , P.GPCH_ROW_NUM FROM PS_GPCH_OT_DATA P , PSOPRDEFN O WHERE P.EMPLID = O.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 GPCH_ROW_NUM Number(5,0) INTEGER NOT NULL Row Number