EODC_CATEGORYD=Document
F=Form
SD_RECNAMEEODC_DOCTYPE_VW(SQL View) |
Index Back |
|---|---|
Document/Form Type Prompt |
| SELECT 'F' , SD_RECNAME , DESCR100 FROM PS_FS_SD_REC WHERE BASE_RECNAME='FORM' AND SD_REC_STATUS ='A' UNION SELECT EODC_CATEGORY , EO_DOCTYPE , DESCR FROM PS_EODC_DOC_HDR WHERE EODC_CATEGORY ='D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EODC_CATEGORY |
Character(1) | VARCHAR2(1) NOT NULL |
Document Category
D=Document F=Form |
| 2 | SD_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Supplementa Data Record |
| 3 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |