GPJP_PP_AET

(SQL Table)
Index Back

Pay Slip State Record

State records used with AE program GPJP_PP01_AE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
9 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system
10 GPJP_PAYEE_IND Character(1) VARCHAR2(1) NOT NULL Checkbox that indicates whether a list of payees has been provided for the pay slip generation.
11 TEMP_FLD Character(1) VARCHAR2(1) NOT NULL Temporary Field for App Engine