| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSONAL_DATA.EMPLID
Prompt Table:
PERSONAL_DATA
|
| 2 |
GPCH_RC_PAY_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Pay Year
|
| 3 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 4 |
GPCH_PRINT_OPTIONS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use to select the Print Options for Employees in Law 2006
A=Print Always
B=Print if not zero
C=Print Never
|
| 5 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Default Value: GPCH_SI_COMPANY.ADDRESS_TYPE
Prompt Table:
ADDRESS_TYP_TBL
|
| 6 |
GPCH_AL_FR_TRSP |
Character(1) |
VARCHAR2(1) NOT NULL |
Free Transporattion
0=Follow Accumulator
1=Always Check
2=Never Check
3=Default
Default Value: 3
|
| 7 |
GPCH_TX_CANTEEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Canteen
0=Follow Accumulator
1=Always Check
2=Never Check
3=Default
Default Value: 3
|
| 8 |
GPCH_AL_EXPENSE |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses 13.1.1
0=Follow Accumulator
1=Always Check
2=Never Check
3=Default
Default Value: 3
|
| 9 |
GPCH_AL_EXPEXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective expenses expat 13.1.2
0=Follow Accumulator
1=Always Check
2=Never Check
3=Default
Default Value: 3
|
| 10 |
GPCH_TX_CANTON |
Character(2) |
VARCHAR2(2) NOT NULL |
Canton
Prompt Table:
GPCH_TX_CANT_VW
|
| 11 |
GPCH_LW_PENSIONEER |
Character(1) |
VARCHAR2(1) NOT NULL |
Statement A/B
0=A-Statement
1=B-Statement
3=Default
Default Value: 3
|
| 12 |
GPCH_RP_REMARKS |
Long Character |
CLOB |
Remarks
|