OPRIDRUN_CNTL_IDDefault Value: %date
Prompt Table: SCH_GROUP_TBL
Prompt Table: SCH_DEFN_CMN_VW
Default Value: 1
Prompt Table: SCH_DEFN_ROT_VW
E=Elapsed
F=Flex
P=Punch
SCH_GRP_RNCTRL(SQL Table) |
Index Back |
|---|---|
Run Control Rec for Sch AssignRun Control Record for Schedule Assignment |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | SCHEDULE_GRP | Character(10) | VARCHAR2(10) NOT NULL |
Scheduling Organizational Group Code
Prompt Table: SCH_GROUP_TBL |
| 5 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 6 | SCHEDULE_ID | Character(16) | VARCHAR2(16) NOT NULL |
The Schedule ID is a field used to uniquely identify a Schedule Definition or Schedule Calendar (built out Schedule Definition).
Prompt Table: SCH_DEFN_CMN_VW |
| 7 | ROTATION_ID | Character(10) | VARCHAR2(10) NOT NULL |
Rotation ID
Default Value: 1 Prompt Table: SCH_DEFN_ROT_VW |
| 8 | SCH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Shift Type
E=Elapsed F=Flex P=Punch |