PROCESS_GROUPEFFDTDefault Value: %date
Default Value: ST_PROCESS_GRP.DESCR
Prompt Table: PERSON_NAME
Prompt Table: CURRENCY_CD_TBL
ST_PROCESS_GRP(SQL Table) |
Index Back |
|---|---|
Process Group |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Process Group |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: ST_PROCESS_GRP.DESCR |
| 5 | CONTACT_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Contact - Vacancy Announcement
Prompt Table: PERSON_NAME |
| 6 | COUNTRY_CODE | Character(3) | VARCHAR2(3) NOT NULL | Country Code |
| 7 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |