| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Tile Id
|
| 2 |
REPORT_ENTITY |
Character(5) |
VARCHAR2(5) NOT NULL |
Reporting Entity ID
Prompt Table:
PO_SPEND_EN_SCH
|
| 3 |
SEL_CNTRCT_EXP |
Character(1) |
VARCHAR2(1) NOT NULL |
Contracts Due to Expire Soon
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 4 |
SEL_CNTRCT_SPND |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Spend on PO
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 5 |
SEL_NBR_CNTRCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of Contracts
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 6 |
SEL_NONCNTSPD_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Contract Spend Over Amount
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 7 |
SEL_NONEDIPO_OVER |
Character(1) |
VARCHAR2(1) NOT NULL |
Non EDI POs Over Amount
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 8 |
SEL_PERDT_POSPND |
Character(1) |
VARCHAR2(1) NOT NULL |
Total Period to Date PO Spend
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 9 |
SEL_POAPPR_CYC |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Approval Cycle Time Overdue
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 10 |
SEL_POBACK_DAYS |
Character(1) |
VARCHAR2(1) NOT NULL |
POs Backordered Overdue
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 11 |
SEL_PODISP_CYC |
Character(1) |
VARCHAR2(1) NOT NULL |
PO Dispatch Cycle Time Overdue
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 12 |
SEL_REQPO_CYC |
Character(1) |
VARCHAR2(1) NOT NULL |
Req to PO Cycle Time Overdue
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 13 |
SEL_VOL_EDI_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Volume of EDI POs
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 14 |
SEL_NBR_PO_PERDT |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of POs Period to Date
N=No
S=System
Y=Yes
Y/N Table Edit
Default Value: N
|
| 15 |
NUM_BID_INVI |
Character(1) |
VARCHAR2(1) NOT NULL |
Number of Bidder Invitations
Y/N Table Edit
Default Value: N
|
| 16 |
NUM_BID_PARTICI |
Character(1) |
VARCHAR2(1) NOT NULL |
Participant Percentage
Y/N Table Edit
Default Value: N
|
| 17 |
AWARD_PERCENTAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Award Percentage
Y/N Table Edit
Default Value: N
|