GPCH_TX_LAWDATA(SQL Table) |
Index Back |
|---|---|
EE Employment DataEMPLOYMENT is one of the core records in the database. Use it to record an employee's employment-related data that doesn't tend to change, such as hire date, termination date, and company service date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Default Value: PERSON.EMPLID Prompt Table: PERSON |
| 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_TX_CMPCAR | Character(1) | VARCHAR2(1) NOT NULL |
Company Car
P=private included X=business only |
| 5 | GPCH_TX_ABO | Character(1) | VARCHAR2(1) NOT NULL |
Subscription Paid
P=private include X=business only |
| 6 | GPCH_TX_VERG | Character(1) | VARCHAR2(1) NOT NULL |
Non Lump Payment
X=yes |
| 7 | GPCH_TX_TRANSP | Character(1) | VARCHAR2(1) NOT NULL |
Free Transportation
X=yes |
| 8 | GPCH_RP_PRINT_FL | Character(1) | VARCHAR2(1) NOT NULL |
Print LAW
Y/N Table Edit Default Value: Y |
| 9 | GPCH_RP_CUSTOM6 | Character(120) | VARCHAR2(120) NOT NULL | Custom Message6 |
| 10 | GPCH_RP_CUSTOM7 | Character(120) | VARCHAR2(120) NOT NULL | Custom Message7 |
| 11 | GPCH_RP_CUSTOM8 | Character(120) | VARCHAR2(120) NOT NULL | Custom Message8 |
| 12 | GPCH_RP_CUSTOM9 | Character(120) | VARCHAR2(120) NOT NULL | Custom Message9 |
| 13 | GPCH_RP_CUSTOM10 | Character(120) | VARCHAR2(120) NOT NULL | Custom Message10 |
| 14 | ADDRESS_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Address Type
Default Value: HOME Prompt Table: ADDRESS_TYP_TBL |