TL_RUNCNTL_AET(SQL Table) |
Index Back |
|---|---|
State record for Run controlState Record for Groups Resolutions App Engine. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | RUN_CTRL_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Run Control Type
AP=Approval CC=Create T&L Business Calendar CR=Crew Reporting CS=Create Work Schedules CT=Create Time ED=Edit Time LD=Labor Distribution LR=Lumpsum Reporting MC=Mass Change PR=Pattern Reporting PU=Update Payroll RA=Rules Application RF=Refresh Dynamic Groups RR=Range of Date Reporting RS=Resolve Schedules RU=Rapid Update VC=Virtual Task Clean Up |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | GROUP_ID | Character(5) | VARCHAR2(5) NOT NULL | Group ID |
| 8 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 9 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 10 | TL_OUT_RECORD_NM | Character(15) | VARCHAR2(15) NOT NULL | Output record name |
| 11 | START_MINI_DT | Date(10) | DATE | Start Mini Date |
| 12 | END_MINI_DT | Date(10) | DATE | End Mini Date |
| 13 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 14 | GRP_WHERE_CLS | Long Character(4096) | CLOB | Where Clause for Groups |
| 15 | RETURN_CD | Number(2,0) | SMALLINT NOT NULL | Return code from Remote Call |
| 16 | WRKDAY_ID | Character(10) | VARCHAR2(10) NOT NULL | Workday ID |
| 17 | SHIFT_ID | Character(10) | VARCHAR2(10) NOT NULL | Shift ID |
| 18 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 19 | EFFDT | Date(10) | DATE | Effective Date |
| 20 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 21 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 22 | PUNCH_IN | DateTime(26) | TIMESTAMP | Punch In |
| 23 | PUNCH_OUT | DateTime(26) | TIMESTAMP | Punch out |
| 24 | SCH_PRODUCT_IND | Character(2) | VARCHAR2(2) NOT NULL |
Schedule Product Indicator
GP=GP Sch Resolve TL=T&L Sch Resolve |
| 25 | TABLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Table Name |
| 26 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 27 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 28 | SCH_PRIM_ALT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether this is the employee's Primary or Alternate SChedule
A=Alternate P=Primary |
| 29 | SCH_ORIDE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
This Option determines whether preference is given to Schedule Overrides entered through the PS Online pages over those imported from a Third Party system or not.
L=Take Last Update O=Take Online Override |
| 30 | TL | Character(1) | VARCHAR2(1) NOT NULL | PS/Time and Labor Product |
| 31 | INSTALLED_PAY_GBL | Character(1) | VARCHAR2(1) NOT NULL | Global Payroll Core |
| 32 | SCH_BASE_TZ | Character(8) | VARCHAR2(8) NOT NULL | Base Timezone used in schedule reolution |
| 33 | NO_PAY_ROWS | Character(1) | VARCHAR2(1) NOT NULL | Publish unmapped TRC as No Pay |