EODI_DYN_IDFIELDNAMEPrompt Table: EODI_DYN_FLD_VW
EODI_DYN_XLATS(SQL View) |
Index Back |
|---|---|
XLAT ViewXLAT View |
| SELECT A.EODI_DYN_ID , A.FIELDNAME , X.FIELDVALUE , X.XLATLONGNAME FROM PS_EODI_DYN_FIELDS A , PSXLATITEM X WHERE A.FIELDNAME = X.FIELDNAME AND A.EODI_FIELD_TYPE = 'X' AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM A, X, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EODI_DYN_ID |
Character(15) | VARCHAR2(15) NOT NULL | Display ID |
| 2 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: EODI_DYN_FLD_VW |
| 3 | EODI_FIELDVALUE | Character(30) | VARCHAR2(30) NOT NULL | XLAT Field Value |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |