DP_POLFLD_SELS(SQL Table) |
Index Back |
---|---|
DP_POLFLD_SELSDP_POLFLD_SELS |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | DP_POLICYSET | Character(10) | VARCHAR2(10) NOT NULL | DP_POLICYSET |
2 | DP_FIELDID | 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_AVAILON_IPINQ | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_IPINQ
Y/N Table Edit |
6 | DP_AVAILON_CSUMG | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Y/N Table Edit |
7 | DP_AVAILON_REFRESH | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_REFRESH
Y/N Table Edit |
8 | DP_AVAILON_IPIMP | Character(1) | VARCHAR2(1) NOT NULL |
DP_AVAILON_IPIMP
Y/N Table Edit |
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
Default Value: N |
15 | DP_AVAILON_PUBIP | Character(1) | VARCHAR2(1) NOT NULL | DP_AVAILON_PUBFCST |
16 | DP_AVAILON_PUBINQ | Character(1) | VARCHAR2(1) NOT NULL | DP_AVAILON_WQPURGE |