DP_CONFIGVIEWDP_LIFEPROFILEPrompt Table: DP_LIFEPROFILES
DP_LIFEPROF_VW(SQL View) |
Index Back |
|---|---|
DP_LIFEPROF_VWDP_LIFEPROF_VW |
| SELECT DP_CONFIGVIEW ,DP_LIFEPROFILE , DP_CONFIGLEVEL , DP_CAPTION , DP_LIFEDURATION FROM PS_DP_LIFEPROFILES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DP_CONFIGVIEW |
Character(20) | VARCHAR2(20) NOT NULL | DP_CONFIGVIEW |
| 2 | DP_LIFEPROFILE |
Character(10) | VARCHAR2(10) NOT NULL |
DP_LIFEPROFILE
Prompt Table: DP_LIFEPROFILES |
| 3 | DP_CONFIGLEVEL | Number(2,0) | SMALLINT NOT NULL | DP_CONFIGLEVEL |
| 4 | DP_CAPTION | Character(30) | VARCHAR2(30) NOT NULL | DP_CAPTION |
| 5 | DP_LIFEDURATION | Number(3,0) | SMALLINT NOT NULL | DP_LIFEDURATION |