PSARCH_IDDP_CONFIGVIEWPrompt Table: DP_CONFIGVIEWS
DP_CONFIGLEVELPrompt Table: DP_CONFIGLEVELS
DP_CAPTIONUSEC=Caption
D=Description
DP_SEQNUMBERDefault Value: 1
F=Field
T=Text
Prompt Table: DP_VWFLDSEL6_VW
DPA_FCITMCAPLIN(SQL Table) |
Index Back |
|---|---|
DP Archive RecordOnline: DP_FCITMCAPLINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL |
DP_CONFIGVIEW
Prompt Table: DP_CONFIGVIEWS |
| 3 | DP_CONFIGLEVEL |
Number(2,0) | SMALLINT NOT NULL |
DP_CONFIGLEVEL
Prompt Table: DP_CONFIGLEVELS |
| 4 | DP_CAPTIONUSE |
Character(1) | VARCHAR2(1) NOT NULL |
DP_CAPTIONUSE
C=Caption D=Description |
| 5 | DP_SEQNUMBER |
Number(10,0) | DECIMAL(10) NOT NULL |
MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.
Default Value: 1 |
| 6 | DP_CAPTIONTYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_CAPTIONTYPE
F=Field T=Text |
| 7 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 8 | DP_FIELDLENGTH | Number(2,0) | SMALLINT NOT NULL | DP_FIELDLENGTH |
| 9 | DP_FIELDID | Character(24) | VARCHAR2(24) NOT NULL |
DP_FIELDID
Prompt Table: DP_VWFLDSEL6_VW |