SETIDCS_DOCUMENT_TYPE001=Main Document
002=Amendment
003=Preview Document
004=Compare File
FIELDNAMEC=Char
D=Date
I=Integer
N=Number
Y/N Table Edit
CS_DOCT_D_UFLD(SQL View) |
Index Back |
|---|---|
Doc Type DATE user def fields1/7/2008 cel Doc Type DATE user def fields |
| SELECT A.SETID , A.CS_DOCUMENT_TYPE , A.FIELDNAME ,A.CS_USER_DEF_TYPE ,A.ENABLED FROM PS_CS_DOCTYPE_UFLD A WHERE A.CS_USER_DEF_TYPE = 'D' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CS_DOCUMENT_TYPE |
Character(20) | VARCHAR2(20) NOT NULL |
Document Type
001=Main Document 002=Amendment 003=Preview Document 004=Compare File |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | CS_USER_DEF_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type
C=Char D=Date I=Integer N=Number |
| 5 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
Y/N Table Edit |