| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
TD_PGLT |
Character(1) |
VARCHAR2(1) NOT NULL |
Current Pagelet
R=Review Promotions
|
| 3 |
TD_PROMO_STAT_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Approved
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_01
|
| 4 |
TD_PROMO_STAT_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Cancelled
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_02
|
| 5 |
TD_PROMO_STAT_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_03
|
| 6 |
TD_PROMO_STAT_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Rejected
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_04
|
| 7 |
TD_PROMO_STAT_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Management Approved
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_05
|
| 8 |
TD_PROMO_STAT_06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Management Rejected
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_06
|
| 9 |
TD_PROMO_STAT_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Approval
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_07
|
| 10 |
TD_PROMO_STAT_08 |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_08
|
| 11 |
TD_PROMO_STAT_09 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalled
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_09
|
| 12 |
TD_PROMO_STAT_10 |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Default Value: TD_PGLT_STAT_OP.TD_PROMO_STAT_10
|
| 13 |
TD_ALLOW_STAT_01 |
Character(1) |
VARCHAR2(1) NOT NULL |
Planned
Default Value: TD_PGLT_STAT_OP.TD_ALLOW_STAT_01
|
| 14 |
TD_ALLOW_STAT_02 |
Character(1) |
VARCHAR2(1) NOT NULL |
Released
Default Value: TD_PGLT_STAT_OP.TD_ALLOW_STAT_02
|
| 15 |
TD_ALLOW_STAT_03 |
Character(1) |
VARCHAR2(1) NOT NULL |
Pending Approval
Default Value: TD_PGLT_STAT_OP.TD_ALLOW_STAT_03
|
| 16 |
TD_ALLOW_STAT_04 |
Character(1) |
VARCHAR2(1) NOT NULL |
Approved
Default Value: TD_PGLT_STAT_OP.TD_ALLOW_STAT_04
|
| 17 |
TD_ALLOW_STAT_05 |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejected
Default Value: TD_PGLT_STAT_OP.TD_ALLOW_STAT_05
|
| 18 |
TD_ALLOW_STAT_06 |
Character(1) |
VARCHAR2(1) NOT NULL |
Closed
Default Value: TD_PGLT_STAT_OP.TD_ALLOW_STAT_06
|
| 19 |
TD_ALLOW_STAT_07 |
Character(1) |
VARCHAR2(1) NOT NULL |
Recalled
Default Value: TD_PGLT_STAT_OP.TD_ALLOW_STAT_07
|
| 20 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_PGLT_TD_VW
|
| 21 |
FROM_SALES_PER |
Character(8) |
VARCHAR2(8) NOT NULL |
From Sales Period
Prompt Table:
CAL_PGLT_TD_VW3
|
| 22 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 23 |
CALENDAR_ID_2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar Id
Prompt Table:
CAL_PGLT_TD_VW
|
| 24 |
TO_SALES_PER |
Character(8) |
VARCHAR2(8) NOT NULL |
To Sales Period
Prompt Table:
CAL_PGLT_TD_VW2
|
| 25 |
END_DT |
Date(10) |
DATE |
End Date
|