UPG_GPJP890_AET

(SQL Table)
Index Back

State record for 8.8x - 8.9

State record for 8.8x - 8.9

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_TEST_FLAG Character(1) VARCHAR2(1) NOT NULL Test Flag
3 SQL_ROW_COUNT Number(8,0) INTEGER NOT NULL Convenient AE State Record field for managing the count of affected rows when %SQLRows is not applicable.
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EFFDT Date(10) DATE Effective Date
6 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
7 GPJP_TAX_ESTAB_TYP Character(2) VARCHAR2(2) NOT NULL Tax Establishment Type.
IT=Tax Establishment
LA=Labor Ins Establishment
SC=Social Ins Establishment
8 GPJP_LA_ESTAB_NO Character(13) VARCHAR2(13) NOT NULL Unemployment Cert.
9 GPJP_EI_NUM Character(13) VARCHAR2(13) NOT NULL Employment Insurance Insured ID Number.
10 GPJP_IT_SUBJ_DED Character(1) VARCHAR2(1) NOT NULL Dependent Subjected to Deduction Flag
11 GPJP_PARENT_LWP Character(1) VARCHAR2(1) NOT NULL Parent Living with Payee
12 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
13 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
14 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
15 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
16 SUPV_LVL_ID Character(8) VARCHAR2(8) NOT NULL Supervisor Level ID for use in capability grade system