OPRIDPrompt Table: OPERATOR_VW
RUN_CNTL_IDGB_GROUP_IDPrompt Table: GB_GROUP_SEC_VW
GB_EFFDTDefault Value: %DATE
Default Value: %DATE
VC_RUN_VCP001(SQL Table) |
Index Back |
|---|---|
VC Group Overlap Run Temp TblVC Group Member Overlap Run Temporary Table |
| # | 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: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_SEC_VW |
| 4 | GB_EFFDT |
Date(10) | DATE NOT NULL |
Group As Of Date
Default Value: %DATE |
| 5 | GB_REFINE_DATE | Date(10) | DATE NOT NULL |
Refinement Date
Default Value: %DATE |
| 6 | VERSIONGBQDM | Number(10,0) | DECIMAL(10) NOT NULL | Version Number |