DP_FIELD_SELS(SQL Table) |
Index Back |
---|---|
System Table |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DP_FIELDID | Character(24) | VARCHAR2(24) NOT NULL | DP_FIELDID |
2 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
3 | DP_DATATYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_DATATYPE
0=Character 1=Long Character 2=Number 3=Signed Number 4=Date |
4 | DP_ISUDFLD | Character(1) | VARCHAR2(1) NOT NULL |
DP_ISUDFLD
Y/N Table Edit |
5 | DP_ISVIEWINFO | Character(1) | VARCHAR2(1) NOT NULL |
DP_ISVIEWINFO
Y/N Table Edit |
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 |
11 | DP_AVAILON_FCREF | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_FCREF
Y/N Table Edit |
12 | DP_AVAILON_ERRSEL | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ERRSEL
Y/N Table Edit |
13 | DP_AVAILON_ARTOUSE | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ARTOUSE
Y/N Table Edit |
14 | DP_AVAILON_ADJHIST | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ADJHIST
Y/N Table Edit |
15 | DP_AVAILON_SUMM | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_SUMM
Y/N Table Edit |
16 | DP_AVAILON_EVINQ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_EVINQ
Y/N Table Edit |
17 | DP_AVAILON_FCINQCH | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_FCINQCH
Y/N Table Edit |
18 | DP_AVAILON_ADJCHRT | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ADJCHRT
Y/N Table Edit |
19 | DP_AVAILON_EIFCI | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_EIFCI
Y/N Table Edit |
20 | DP_AVAILON_FUNCAUD | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_FUNCAUD
Y/N Table Edit |
21 | DP_AVAILON_ROLESEC | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ROLESEC
Y/N Table Edit |
22 | DP_AVAILON_EIUPD | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_EIUPD
Y/N Table Edit |
23 | DP_AVAILON_PUBFCST | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFCST
Y/N Table Edit |
24 | DP_AVAILON_PUBFLTR | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit |
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 |
27 | DP_AVAILON_BAMSPEC | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_BAMSPEC
Y/N Table Edit |
28 | DP_AVAILON_INTADJ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_INTADJ
Y/N Table Edit |
29 | DP_AVAILON_INTDMD | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_INTDMD
Y/N Table Edit |
30 | DP_AVAILON_INTFCI | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_INTFCI
Y/N Table Edit |
31 | DP_AVAILON_INTUP | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_INTUP
Y/N Table Edit |
32 | DP_AVAILON_AHISSEL | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment History
Y/N Table Edit |
33 | DP_AVAILON_BPPUB | Character(1) | VARCHAR2(1) NOT NULL |
Publish for Business Planning
Y/N Table Edit |
34 | DP_AVAILON_PUBINQ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_WQPURGE
Y/N Table Edit |
35 | DP_AVAILON_DPIFACE | Character(1) | VARCHAR2(1) NOT NULL | DP_AVAILON_ARTOUSE |
36 | DP_AVAILON_MMSELCT | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Y/N Table Edit Default Value: N |
37 | DP_AVAILON_DHISINQ | Character(1) | VARCHAR2(1) NOT NULL | DP_AVAILON_CSUMG |
38 | DP_AVAILON_DYNREL | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit Default Value: N |
39 | DP_AVAILON_PRORATE | Character(1) | VARCHAR2(1) NOT NULL | DP_AVAILON_SUMM |
40 | DP_AVAILON_IIMP | 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 |