DP_VIEWFLD_SELS(SQL Table) |
Index Back |
|---|---|
System TableSystem Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW | |
| 2 | Character(24) | VARCHAR2(24) NOT NULL | DP_FIELDID | |
| 3 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 4 | DP_DATATYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_DATATYPE
0=Character 1=Long Character 2=Number 3=Signed Number 4=Date |
| 5 | DP_KEYFIELD | Character(1) | VARCHAR2(1) NOT NULL |
DP_KEYFIELD
Y/N Table Edit Default Value: N |
| 6 | DP_AVAILON_CALCODE | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CALCODE
Y/N Table Edit Default Value: N |
| 7 | DP_AVAILON_MAMAINT | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_MAMAINT
Y/N Table Edit Default Value: N |
| 8 | DP_AVAILON_POLSETS | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_POLSETS
Y/N Table Edit Default Value: N |
| 9 | DP_AVAILON_FCINQ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_FCINQ
Y/N Table Edit Default Value: N |
| 10 | DP_AVAILON_FCITCAP | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_FCITCAP
Y/N Table Edit Default Value: N |
| 11 | DP_AVAILON_FCREF | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_FCREF
Default Value: N |
| 12 | DP_AVAILON_ERRSEL | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ERRSEL
Y/N Table Edit Default Value: N |
| 13 | DP_AVAILON_ARTOUSE | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ARTOUSE
Y/N Table Edit Default Value: N |
| 14 | DP_AVAILON_ADJHIST | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ADJHIST
Y/N Table Edit Default Value: N |
| 15 | DP_AVAILON_SUMM | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_SUMM
Y/N Table Edit Default Value: N |
| 16 | DP_AVAILON_EVINQ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_EVINQ
Y/N Table Edit Default Value: N |
| 17 | DP_AVAILON_FCINQCH | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_FCINQCH
Y/N Table Edit Default Value: N |
| 18 | DP_AVAILON_ADJCHRT | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ADJCHRT
Y/N Table Edit Default Value: N |
| 19 | DP_AVAILON_EIFCI | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_EIFCI
Y/N Table Edit Default Value: N |
| 20 | DP_AVAILON_FUNCAUD | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_FUNCAUD
Y/N Table Edit Default Value: N |
| 21 | DP_AVAILON_ROLESEC | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ROLESEC
Y/N Table Edit Default Value: N |
| 22 | DP_AVAILON_EIUPD | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_EIUPD
Y/N Table Edit Default Value: N |
| 23 | DP_AVAILON_PUBFCST | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFCST
Y/N Table Edit Default Value: N |
| 24 | DP_AVAILON_PUBFLTR | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit Default Value: N |
| 25 | DP_AVAILON_PUBARAY | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit Default Value: N |
| 26 | DP_AVAILON_WQPURGE | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_WQPURGE
Y/N Table Edit Default Value: N |
| 27 | DP_AVAILON_BAMSPEC | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_BAMSPEC
Y/N Table Edit Default Value: N |
| 28 | DP_AVAILON_INTADJ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_INTADJ
Y/N Table Edit Default Value: N |
| 29 | DP_AVAILON_INTDMD | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_INTDMD
Y/N Table Edit Default Value: N |
| 30 | DP_AVAILON_INTFCI | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_INTFCI
Y/N Table Edit Default Value: N |
| 31 | DP_AVAILON_INTUP | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_INTUP
Y/N Table Edit Default Value: N |
| 32 | DP_AVAILON_AHISSEL | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment History
Y/N Table Edit Default Value: N |
| 33 | DP_AVAILON_BPPUB | Character(1) | VARCHAR2(1) NOT NULL |
Publish for Business Planning
Y/N Table Edit Default Value: N |
| 34 | DP_AVAILON_PUBINQ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_WQPURGE
Y/N Table Edit Default Value: N |
| 35 | DP_AVAILON_DPIFACE | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ARTOUSE
Default Value: N |
| 36 | DP_AVAILON_MMSELCT | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Y/N Table Edit Default Value: N |
| 37 | DP_AVAILON_DYNREL | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit Default Value: N |
| 38 | DP_AVAILON_PRORATE | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_SUMM
Default Value: N |
| 39 | DP_AVAILON_IIMP | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N |
| 40 | DP_AVAILON_DHISINQ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N |
| 41 | DP_AVAILON_EIMPADJ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N |
| 42 | DP_AVAILON_EIMPDMD | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N |
| 43 | DP_AVAILON_EIMPFCI | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N |
| 44 | DP_AVAILON_EIMPUPD | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N |