GPES_RC_SS1

(SQL Table)
Index Back

Run Control for TCs Generation

Run 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/Surcharge Bases Increa
L91=Retro w/Surchage new Slices
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