DP_IPFIELD_SELS(SQL Table) |
Index Back |
---|---|
IP Field Sels TableIP Field Sels 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_AVAILON_IPINQ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_IPINQ
Y/N Table Edit Default Value: N |
5 | DP_AVAILON_CSUMG | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Y/N Table Edit Default Value: N |
6 | DP_ISUDFLD | Character(1) | VARCHAR2(1) NOT NULL |
DP_ISUDFLD
Y/N Table Edit Default Value: N |
7 | DP_AVAILON_REFRESH | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_REFRESH
Y/N Table Edit Default Value: N |
8 | DP_AVAILON_IPIMP | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_IPIMP
Y/N Table Edit Default Value: N |
9 | DP_AVAILON_ROLESEC | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_ROLESEC
Y/N Table Edit Default Value: N |
10 | DP_AVAILON_IPWQPUR | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_IPWQPUR
Y/N Table Edit Default Value: N |
11 | DP_AVAILON_BAMSPEC | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_BAMSPEC
Y/N Table Edit Default Value: N |
12 | DP_AVAILON_PUBFCST | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFCST
Y/N Table Edit Default Value: N |
13 | DP_AVAILON_PUBFLTR | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit Default Value: N |
14 | DP_AVAILON_IPEXIMP | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_IPEXIMP
Y/N Table Edit Default Value: N |
15 | DP_AVAILON_PUBIP | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFCST
Y/N Table Edit Default Value: N |
16 | DP_AVAILON_PUBINQ | Character(1) | VARCHAR2(1) NOT NULL | DP_AVAILON_WQPURGE |