| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 2 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
Prompt Table:
BUS_CAL_HOL_DFN
|
| 3 |
ALT_STAT_DESC_OT |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Status Description - On Time
|
| 4 |
ALT_STAT_DESC_AR |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Status Description - At Risk
|
| 5 |
ALT_STAT_DESC_BS |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Status Description - Behind Schedule
|
| 6 |
ALT_COLOR_OT |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Visual Color - On Time
|
| 7 |
ALT_COLOR_AR |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Visual Color - At Risk
|
| 8 |
ALT_COLOR_BS |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Visual Color - Behind Schedule
|
| 9 |
PST_DUE_TASKS_OT |
Number(3,0) |
SMALLINT NOT NULL |
Number of Past Due Tasks - On Time
|
| 10 |
PST_DUE_TASKS_AR |
Number(3,0) |
SMALLINT NOT NULL |
Number of Past Due Tasks - On Time
Default Value: 5
|
| 11 |
PST_DUE_TASKS_BS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Past Due Tasks - Behind Schedule
Default Value: 8
|
| 12 |
DFLT_GRACE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Default Grace Period in days
|
| 13 |
CHK_CPS_AT |
Character(1) |
VARCHAR2(1) NOT NULL |
Change of Plan Status - Assigned To
N=No
Y=Yes
Default Value: N
|
| 14 |
CHK_CPS_CO |
Character(1) |
VARCHAR2(1) NOT NULL |
Change of Plan Status - Current Owner
N=No
Y=Yes
Default Value: N
|
| 15 |
CHK_CPS_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Change of Plan Status - Plan Owner
N=No
Y=Yes
Default Value: N
|
| 16 |
CHK_CTS_AT |
Character(1) |
VARCHAR2(1) NOT NULL |
Change of Task Status - Assigned To
N=No
Y=Yes
Default Value: N
|
| 17 |
CHK_CTS_CO |
Character(1) |
VARCHAR2(1) NOT NULL |
Change of Task Status - Current Owner
N=No
Y=Yes
Default Value: N
|
| 18 |
CHK_CTS_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Change of Task Status - Plan Owner
N=No
Y=Yes
Default Value: N
|
| 19 |
CHK_PTC_AT |
Character(1) |
VARCHAR2(1) NOT NULL |
Predecessor Task Completion - Assigned To
N=No
Y=Yes
Default Value: N
|
| 20 |
CHK_PTC_CO |
Character(1) |
VARCHAR2(1) NOT NULL |
Predecessor Task Completion - Current Owner
N=No
Y=Yes
Default Value: N
|
| 21 |
CHK_PTC_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Predecessor Task Completion - Plan Owner
N=No
Y=Yes
Default Value: N
|
| 22 |
CHK_NVC_AT |
Character(1) |
VARCHAR2(1) NOT NULL |
New Version Created - Assigned To
N=No
Y=Yes
Default Value: N
|
| 23 |
CHK_NVC_CO |
Character(1) |
VARCHAR2(1) NOT NULL |
New Version Created - Current Owner
N=No
Y=Yes
Default Value: N
|
| 24 |
CHK_NVC_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
New Version Created - Plan Owner
N=No
Y=Yes
Default Value: N
|
| 25 |
CHK_COP_AT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancellation of Plan - Assigned To
N=No
Y=Yes
Default Value: N
|
| 26 |
CHK_COP_CO |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancellation of Plan - Current Owner
N=No
Y=Yes
Default Value: N
|
| 27 |
CHK_COP_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Cancellation of Plan - Plan Owner
N=No
Y=Yes
Default Value: N
|