SD_RECNAMEEODC_PNGR_RECNAMEEODC_FIELDNAMELANGUAGE_CDEODC_SDRCFLD_LG(SQL View) |
Index Back |
|---|---|
Form FieldNames to store dataListing the Form Fieldnames in which the form field data is being stored. |
| SELECT A.SD_RECNAME , B.RECNAME , A2.FIELDNAME , A.LANGUAGE_CD , A.LABEL18 , CASE WHEN A.FORM_LONG_LABEL <> ' ' THEN A.FORM_LONG_LABEL ELSE A.LABEL18 END FROM PS_FS_SD_RECFLD_LG A , PS_FS_SD_RECFLD A2 , PS_FS_SD_REC B WHERE A.SD_RECNAME = B.SD_RECNAME AND A.SD_RECNAME = A2.SD_RECNAME AND A.SD_FLDNAME = A2.SD_FLDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SD_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Supplementa Data Record |
| 2 | EODC_PNGR_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Component Record Name |
| 3 | EODC_FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Component FieldName |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | LABEL18 | Character(18) | VARCHAR2(18) NOT NULL | Label |
| 6 | FORM_LONG_LABEL | Character(100) | VARCHAR2(100) NOT NULL | Long Label |