EODC_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 |