| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 2 |
SSN_EMPLOYER |
Character(13) |
VARCHAR2(13) NOT NULL |
Employer Social Security number
|
| 3 |
GPES_MONTH |
Number(2,0) |
SMALLINT NOT NULL |
Month
|
| 4 |
GPES_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Year
|
| 5 |
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
|
| 6 |
GPES_MONTH_RECALC |
Number(2,0) |
SMALLINT NOT NULL |
Retro month
|
| 7 |
GPES_YEAR_RECALC |
Number(4,0) |
SMALLINT NOT NULL |
Retro year
|
| 8 |
SOCS_ER_CODE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Employer
9=Fiscal Identification Code
|
| 9 |
FISCAL_ID_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Fiscal Identification Code
|
| 10 |
INSUR_COMP_CD_ESP |
Character(5) |
VARCHAR2(5) NOT NULL |
Insurance Company Code
|
| 11 |
GPES_TC_TOT_EE |
Number(5,0) |
INTEGER NOT NULL |
Total Employees.Field used in TC1 Report.
|
| 12 |
GPES_MONTHCD_FROM |
Character(2) |
VARCHAR2(2) NOT NULL |
Month from
|
| 13 |
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
|
| 14 |
GPES_TC_BS_CC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Common Contingencies Base. Field used in TC1 Report.
|
| 15 |
GPES_TC_BS_CP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Professional Contingencies Base. Field used in TC1 Report.
|
| 16 |
GPES_TC_BS_HE |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Structural Overtime Base. Field used in TC1 Report.
|
| 17 |
GPES_TC_BS_HN |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Non-Structural Overtime Base. Field used in TC1 Report.
|
| 18 |
GPES_TC_BS_CCER |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Common Contingencies Base (Employer Only). Field used in TC1 Report.
|
| 19 |
GPES_TC_BS_CPER |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Professional Contingencies Base (Employer Only). Field used in TC1 Report.
|
| 20 |
GPES_TC_BS_CP42 |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Social Security CP base for BA42.
|
| 21 |
GPES_TC_PCT_CC |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Common Contingencies Percent. Field used in TC1 Report.
|
| 22 |
GPES_TC_PCT_CP |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Professional Contingencies Percent. Field used in TC1 Report.
|
| 23 |
GPES_TC_PCT_HE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Structural Overtime Percent. Field used in TC1 Report.
|
| 24 |
GPES_TC_PCT_HN |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Non-Structural Overtime Percent. Field used in TC1 Report.
|
| 25 |
GPES_TC_PCT_CCER |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Common Contingencies Percent (Employer Only). Field used in TC1 Report.
|
| 26 |
GPES_TC_PCT_CPER |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Professional Contingencies Percent (Employer Only). Field used in TC1 Report.
|
| 27 |
GPES_TC_CT_CC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Common Contingencies Contribution. Field used in TC1 Report.
|
| 28 |
GPES_TC_CT_CP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Professional Contingencies Contribution. Field used in TC1 Report.
|
| 29 |
GPES_TC_CT_HE |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Structural Overtime Contribution. Field used in TC1 Report.
|
| 30 |
GPES_TC_CT_HN |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Non-Structural Overtime Contribution. Field used in TC1 Report.
|
| 31 |
GPES_TC_CT_IMS |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
IMS Contribution. Field used in TC1 Report.
|
| 32 |
GPES_TC_CT_IT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
IT Contribution. Field used in TC1 Report.
|
| 33 |
GPES_TC_CT_IT_IMS |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
IT & IMS Contribution. Field used in TC1 Report.
|
| 34 |
GPES_TC_CT_CCER |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Common Contingencies Contribution (Employer Only). Field used in TC1 Report.
|
| 35 |
GPES_TC_CT_CPER |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Professional Contingencies Contribution (Employer Only). Field used in TC1 Report.
|
| 36 |
GPES_TC_COMP_ATEP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Work accident compensation.Field used in TC1 Report.
|
| 37 |
GPES_TC_COMP_BONIF |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Bonification.Field used in TC1 Report.
|
| 38 |
GPES_TC_COMP_IT |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
IT compensation.Field used in TC1 Report.
|
| 39 |
GPES_TC_COMP_ITRED |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
IT Reduction.Field used in TC1 Report.
|
| 40 |
GPES_TC_COMP_RED |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Reduction.Field used in TC1 Report.
|
| 41 |
GPES_TC_COMP_OTHER |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other reductions.Field used in TC1 Report.
|
| 42 |
GPES_TC_TOT_CC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Common Contingencies contribution total amount.Field used in TC1 Report.
|
| 43 |
GPES_TC_TOT_CP |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Professional Contingencies contribution total amount.Field used in TC1 Report.
|
| 44 |
GPES_TC_TOT_OTR |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Other contribution total amount. Field used in TC1 Report.
|
| 45 |
GPES_TC_BS_PENALTY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Penalty Base.Field used in TC1 Report.
|
| 46 |
GPES_TC_PCT_PENLTY |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Penalty Percent.Field used in TC1 Report.
|
| 47 |
GPES_TC_PENALTY |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Penalty Amount.Field used in TC1 Report.
|
| 48 |
GPES_TC_TOT_TC1NEG |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Amount to pay. Field used in TC1 Report.
|
| 49 |
GPES_TC_TOT_TC1POS |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Amount to pay back. Field used in TC1 Report.
|
| 50 |
GPES_SSTC_TC1GEN |
Character(1) |
VARCHAR2(1) NOT NULL |
TC1 Generated indicator. This field is used to control the TC1 report generation.
|
| 51 |
GPES_TC_RED_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Reduction Type
1=INEM Reduction
2=CC Reduction
5=Both Reductions
|
| 52 |
GPES_S_INS_PCT_AT |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Self-Insurance reduction rate for work-related injury or occupational disease (AT/EP)
|
| 53 |
GPES_TC_CT_ER_SSC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Common Services Contribution quota
|
| 54 |
GPES_TC_BS_S_INS |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Regular situations joint-management deduction base
|
| 55 |
GPES_S_INS_PCT_NAT |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Self-Insurance reduction rate for common disease or non-work-related injury (non-AT/EP)
|
| 56 |
GPES_TC_RED_S_INS |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Regular situations joint-management deduction quota
|
| 57 |
GPES_TC_KEY_OC |
Character(1) |
VARCHAR2(1) NOT NULL |
Key for Other Concepts (Contracts with duration of less than seven days)
|
| 58 |
GPES_TC_BS_OC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Contribution Base for Other Concepts (Contracts with duration of less than seven days)
|
| 59 |
GPES_TC_PCT_OC |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage for Other Concepts (Contracts with duration of less than seven days)
|
| 60 |
GPES_TC_CT_OC |
Signed Number(13,2) |
DECIMAL(11,2) NOT NULL |
Contribution Quota Employer for Other Concepts (Contracts with duration of less than seven days)
|