EMPLIDPrompt Table: PERSON
CONTRACT_NUMEFFDTEMPL_CLS_ESP(SQL Table) |
Index Back |
|---|---|
Employee Contrct Clauses ESPEmployee Contrct Clauses. Used in Contract Printing. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 2 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | LINE1_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 1 |
| 5 | LINE2_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 2 |
| 6 | LINE3_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 3 |
| 7 | LINE4_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 4 |
| 8 | LINE5_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 5 |
| 9 | LINE6_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 6 |
| 10 | LINE7_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 7 |
| 11 | LINE8_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 8 |
| 12 | LINE9_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 9 |
| 13 | LINE10_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 10 |
| 14 | LINE11_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 11 |
| 15 | LINE12_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 12 |
| 16 | LINE13_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 13 |
| 17 | LINE14_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 14 |
| 18 | LINE15_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 15 |
| 19 | LINE16_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 16 |
| 20 | LINE17_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 17 |
| 21 | LINE18_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 18 |
| 22 | LINE19_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 19 |
| 23 | LINE20_ESP | Character(150) | VARCHAR2(150) NOT NULL | Clause Line 20 |
| 24 | LINE21_ESP | Character(150) | VARCHAR2(150) NOT NULL | UPD28450515 |
| 25 | LINE22_ESP | Character(150) | VARCHAR2(150) NOT NULL | UPD28450515 |
| 26 | LINE23_ESP | Character(150) | VARCHAR2(150) NOT NULL | UPD28450515 |
| 27 | LINE24_ESP | Character(150) | VARCHAR2(150) NOT NULL | UPD28450515 |
| 28 | LINE25_ESP | Character(150) | VARCHAR2(150) NOT NULL | UPD28450515 |
| 29 | LINE26_ESP | Character(150) | VARCHAR2(150) NOT NULL | UPD28450515 |
| 30 | LINE27_ESP | Character(150) | VARCHAR2(150) NOT NULL | UPD28450515 |
| 31 | LINE28_ESP | Character(150) | VARCHAR2(150) NOT NULL | UPD28450515 |
| 32 | CNT_CLAUSES_ESP | Long Character | CLOB | All Clauses in One |