GPES_RC_SS1(SQL Table) |
Index Back |
---|---|
Run Control for TCs GenerationRun Control for TCs Generation |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | SSN_EMPLOYER | Character(13) | VARCHAR2(13) NOT NULL |
Employer Social Security number
Prompt Table: GPES_SS_WC_VW |
4 | GPES_SSTC_PAYMNT | Character(3) | VARCHAR2(3) NOT NULL |
Payment Type. This field is used to populate the GP Write Array, which is used to generate the FAN File.
L00=Regular L02=Litigation Salary L03=Retroactivity wo/Surcharge L04=Reductions Payback L09=Retroactivity w/Surcharge L13=Vacations L90=Retro w/Surch. Base Incr. L91=Retro w/Surch. New Slices V03=Retro wo/ Surcharge Vacations V90=Retro w/ Surcharge Vacations |
5 | YEARCD | Character(4) | VARCHAR2(4) NOT NULL | Calendar Year |
6 | GPES_MONTHCD | Character(2) | VARCHAR2(2) NOT NULL |
Month
01=01 - January 02=02 - February 03=03 - March 04=04 - April 05=05 - May 06=06 - June 07=07 - July 08=08 - August 09=09 - September 10=10 - October 11=11 - November 12=12 - December |
7 | GPES_SSTC_TC1GEN | Character(1) | VARCHAR2(1) NOT NULL |
TC1 Generated indicator. This field is used to control the TC1 report generation.
Y/N Table Edit |
8 | GPES_SSTC_TC1RUN | Character(1) | VARCHAR2(1) NOT NULL |
TC1 Run indicator. This field is used to control the TC1 report generation.
Y/N Table Edit |
9 | GPES_SSTC_MESSG1 | Character(25) | VARCHAR2(25) NOT NULL | TC1 Message Line 1 |
10 | GPES_SSTC_MESSG2 | Character(25) | VARCHAR2(25) NOT NULL | TC1 Message Line 2 |
11 | GPES_SSTC_MESSG3 | Character(25) | VARCHAR2(25) NOT NULL | TC1 Message Line 3 |
12 | GPES_SSTC_MESSG4 | Character(25) | VARCHAR2(25) NOT NULL | TC1 Message Line 4 |
13 | GPES_SSTC_MESSG5 | Character(25) | VARCHAR2(25) NOT NULL | TC1 Message Line 5 |
14 | GPES_SSTC_MESSG6 | Character(25) | VARCHAR2(25) NOT NULL | TC1 Message Line 6 |
15 | GPES_SSTC_RPT_DT | Date(10) | DATE | Report Date |