FIELDNAMEPrompt Table: PSDBFIELD
FIELDVALUEEFFDT1=Federal Only
2=Commercial Only
3=Field Value Changed
4=No Change
GVT_XLAT_CFG(SQL Table) |
Index Back |
|---|---|
Federal Xlat Configuration.Federal Xlat Configuration table to store data to override PSXLATITEM table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: PSDBFIELD |
| 2 | FIELDVALUE |
Character(4) | VARCHAR2(4) NOT NULL | Field Value |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 5 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
| 6 | NEW_EFFDT | Date(10) | DATE | New Benefit Program Effdt |
| 7 | NEW_DESCR | Character(30) | VARCHAR2(30) NOT NULL | New Description |
| 8 | NEW_DESCRSHORT | Long Character | CLOB | New Short Description |
| 9 | GVT_FLD | Character(1) | VARCHAR2(1) NOT NULL |
Use to configure federal data.
1=Federal Only 2=Commercial Only 3=Field Value Changed 4=No Change |