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_DOCTYPE_UFLD(SQL Table) |
Index Back |
|---|---|
Doc Type User Def Fields1/7/2008 cel Doc Type user defined fields ... used when they want to override the install settings. |
| # | 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 |