DP_USERDATACODEPrompt Table: DP_USERDATACDS
DP_FIELDIDY/N Table Edit
0=Character
1=Long Character
2=Number
3=Signed Number
4=Date
DP_IP_UDFLDSVW(SQL View) |
Index Back |
|---|---|
IP System Field Sels ViewSELECT A.DP_USERDATACODE , A.DP_FIELDID , A.DP_CAPTION , A.DP_USEDUNUSED , A.DP_FIELDLENGTH , B.DP_DATATYPE FROM PS_DP_USERDATAFLDS A , PS_DP_IPFIELD_SELS B WHERE A.DP_USEDUNUSED = 'Y' AND A.DP_FIELDID = B.DP_FIELDID |
| SELECT A.DP_USERDATACODE , A.DP_FIELDID , A.DP_CAPTION , A.DP_USEDUNUSED , A.DP_FIELDLENGTH , B.DP_DATATYPE FROM PS_DP_USERDATAFLDS A , PS_DP_IPFIELD_SELS B WHERE A.DP_USEDUNUSED = 'Y' AND A.DP_FIELDID = B.DP_FIELDID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_USERDATACODE |
Character(20) | VARCHAR2(20) NOT NULL |
DP_USERDATACODE
Prompt Table: DP_USERDATACDS |
| 2 | DP_FIELDID |
Character(24) | VARCHAR2(24) NOT NULL | DP_FIELDID |
| 3 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 4 | DP_USEDUNUSED | Character(1) | VARCHAR2(1) NOT NULL |
DP_USEDUNUSED
Y/N Table Edit |
| 5 | DP_FIELDLENGTH | Number(2,0) | SMALLINT NOT NULL | DP_FIELDLENGTH |
| 6 | DP_DATATYPE | Character(1) | VARCHAR2(1) NOT NULL |
DP_DATATYPE
0=Character 1=Long Character 2=Number 3=Signed Number 4=Date |