DP_POLICYSETPrompt Table: DP_POLSETS1_VW
DP_SEQNUMBERDP_TOFIELDPrompt Table: DP_IPUDFLDSVW
Prompt Table: DP_FCUDFLDSVW
DP_POLSETUFLDS(SQL Table) |
Index Back |
|---|---|
Policy Set UD FieldsPolicy Set User Data Fields |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_POLICYSET |
Character(10) | VARCHAR2(10) NOT NULL |
DP_POLICYSET
Prompt Table: DP_POLSETS1_VW |
| 2 | DP_SEQNUMBER |
Number(10,0) | DECIMAL(10) NOT NULL | MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field. |
| 3 | DP_TOFIELD |
Character(24) | VARCHAR2(24) NOT NULL |
DP_TOFIELD
Prompt Table: DP_IPUDFLDSVW |
| 4 | DP_FROMFIELD | Character(24) | VARCHAR2(24) NOT NULL |
DP_FROMFIELD
Prompt Table: DP_FCUDFLDSVW |