GPTH_SSO3_AET

(SQL Table)
Index Back

Record for AE of SS0609

Record for application engine of the report SS0609

# 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 GPTH_PRCS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
10 YEAR Character(4) VARCHAR2(4) NOT NULL Character field to represent a year
11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
12 FROM_DT Date(10) DATE From Date
13 TO_DT Date(10) DATE To Date
14 GPTH_SI_BRANCH_NO Character(6) VARCHAR2(6) NOT NULL Social Security Branch Number
15 GPTH_SSF_103 Character(1) VARCHAR2(1) NOT NULL This field represent that if the SSO 1-03 report is run
N=N
Y=Y
16 GPTH_SSF_610 Character(1) VARCHAR2(1) NOT NULL This field represent that if the SSO 6-10 report is run
N=N
Y=Y
17 GPTH_DMF_103 Character(1) VARCHAR2(1) NOT NULL This field represent that if the SSO 1-03 report need an Data Media File
N=N
Y=Y
18 GPTH_DMF_610 Character(1) VARCHAR2(1) NOT NULL This field represent that if the SSO 6-10 report need an Data Media File
N=N
Y=Y