GPTH_SSO3_AET(SQL Table) |
Index Back |
---|---|
Record for AE of SS0609Record 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 |