TL_RUN_CTRL_LAN(SQL Table) |
Index Back |
|---|---|
TR - Run Control TableThis record is used to define the Time and Labor Run Control. |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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 NOT NULL |
Start Date
Default Value: %date |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |