OPRIDPrompt Table: OPRID_VW2
Prompt Table: PO_SPEND_EN_SCH
OPR_DEF_RPT_VW(SQL View) |
Index Back |
|---|---|
User Reporting Entity |
| SELECT oprid , report_entity , rel_start_per , rel_end_per , start_date , end_date FROM PS_OPR_DEF_RPT |
| # | 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_VW2 |
| 2 | REPORT_ENTITY | Character(5) | VARCHAR2(5) NOT NULL |
Reporting Entity ID
Prompt Table: PO_SPEND_EN_SCH |
| 3 | REL_START_PER | Signed Number(4,0) | DECIMAL(3) NOT NULL | Start - Cur Period Minus |
| 4 | REL_END_PER | Signed Number(4,0) | DECIMAL(3) NOT NULL | End - Cur Period Minus |
| 5 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 6 | END_DATE | Date(10) | DATE | End Date |