EMPLIDPrompt Table: PERSON
CONTRACT_NUMDefault Value: %Date
GP_DIAG_CTR_VW(SQL View) |
Index Back |
|---|---|
Contract DataDerivated from CONTRACT_DATA to select fields that could be send from customer to PeopleSoft |
| SELECT EMPLID , CONTRACT_NUM , CONTRACT_BEGIN_DT , CONTRACT_END_DT FROM PS_CONTRACT_DATA |
| # | 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 | CONTRACT_BEGIN_DT | Date(10) | DATE |
Contract Begin Date
Default Value: %Date |
| 4 | CONTRACT_END_DT | Date(10) | DATE | Contract End Date |