RUN_SPR_DM(SQL Table) |
Index Back |
|---|---|
sPro Datamart Run Control TblServices Procurement Datamart Run Control Tbl |
| # | 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 | START_DATE | Date(10) | DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: %Date |
| 5 | SPB_DURATION_DT | Date(10) | DATE NOT NULL |
Duration Start Date
Default Value: %Date |
| 6 | SPF_CURRENT_DATE | Character(1) | VARCHAR2(1) NOT NULL |
Current Month
1=Yes 2=No Y/N Table Edit Default Value: N |
| 7 | SPF_REPORT_MONTHS | Signed Number(4,0) | DECIMAL(3) NOT NULL |
# of Reporting Months
Default Value: -3 |
| 8 | DATE_FROM | Date(10) | DATE | Date From |
| 9 | DATE_TO | Date(10) | DATE | Date To |
| 10 | OPRID_TO_RPT | Character(30) | VARCHAR2(30) NOT NULL |
User ID To Report
Prompt Table: SPR_OPR_PROMPT |
| 11 | SPR_ALL_USER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Run for all SPro Users
1=Yes 2=No N=No Y=Yes Y/N Table Edit Default Value: N |
| 12 | DURATION_MONTH | Number(3,0) | SMALLINT NOT NULL |
Length of Stay Duration in Months
Default Value: 6 |
| 13 | ASOF_DATE | Date(10) | DATE |
As Of Date
Default Value: %Date |
| 14 | LEAVE_PERIOD | Number(3,0) | SMALLINT NOT NULL |
Leave Period used to calculate Start Date of Length of Stay Analysis
Default Value: 2 |