OPRIDDefault Value: OPRID_VW.OPRID
Prompt Table: OPRID_VW
RUN_CNTL_IDPrompt Table: RECON_REQUEST_V
BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_NONVW
POOL_IDPrompt Table: TRP_POOL_ACT_VW
Default Value: %DATE
TRP_INC_RUN(SQL Table) |
Index Back |
|---|---|
Position report run ctrlPosition report run control record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPRID_VW.OPRID Prompt Table: OPRID_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Prompt Table: RECON_REQUEST_V |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
| 4 | POOL_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table: TRP_POOL_ACT_VW |
| 5 | ASOFDATE | Date(10) | DATE NOT NULL |
As of Date
Default Value: %DATE |