GPJP_UC_LD_AET

(SQL Table)
Index Back

Unemployment Cert state record

Unemployment Cert state record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
7 GPJP_START_DATE Date(10) DATE Appraisal Prd Start Date (14-1)
8 GPJP_END_DATE Date(10) DATE Appraisal Prd End Date (14-2)
9 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.
10 GPJP_UC_OVRWRITE Character(1) VARCHAR2(1) NOT NULL Overwrite Certificate data (in GPJP_RC_UC)
11 GPJP_WC_PROC Character(1) VARCHAR2(1) NOT NULL Checkbox that indicates whether a payee being processed is for Wage Certificate or Unemployment Certificate.