RUN_SPB_SUP_SCR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 4 | SPF_SCORE_RULE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Scoring Rule
Default Value: BUS_UNIT_TBL_SP.SPF_SCORE_RULE_ID Prompt Table: SPB_SUP_SCR_DFN |
| 5 | START_DATE | Date(10) | DATE |
Start Date for Gen Standing PO
Default Value: BUS_UNIT_TBL_SP.START_DATE |
| 6 | SPB_DURATION_DT | Date(10) | DATE |
Duration Start Date
Default Value: BUS_UNIT_TBL_SP.SPB_DURATION_DT |
| 7 | SPF_CURRENT_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Current Month
1=Yes 2=No Y/N Table Edit Default Value: BUS_UNIT_TBL_SP.SPF_CURRENT_DATE |
| 8 | SPF_REPORT_MONTHS | Signed Number(4,0) | DECIMAL(3) NOT NULL |
# of Reporting Months
Default Value: BUS_UNIT_TBL_SP.SPF_REPORT_MONTHS |