TL_TA_OPA_AET(SQL Table) |
Index Back |
|---|---|
Main state rec TL TIMEADMIN |
| # | 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 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 5 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 6 | AE_PROGRAM | Character(12) | VARCHAR2(12) NOT NULL | Clear in Program |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 8 | POI_START_DT | Date(10) | DATE | Period of Interest Start |
| 9 | POI_END_DT | Date(10) | DATE | Period of Interest End |
| 10 | BATCH_NUM | Number(4,0) | SMALLINT NOT NULL | Batch Number |
| 11 | STORE_RULE_MAP | Character(1) | VARCHAR2(1) NOT NULL |
Store Rule Level Statistics
Y/N Table Edit |
| 12 | STORE_BTCH_INFO | Character(1) | VARCHAR2(1) NOT NULL |
Store EE Level Statistics
Y/N Table Edit |
| 13 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 14 | WRKGRP_EFFDT | Date(10) | DATE | Workgroup Effective Date |
| 15 | RULE_PGM_ID | Character(12) | VARCHAR2(12) NOT NULL | Rule Program ID |
| 16 | RULEPGM_EFFDT | Date(10) | DATE | Rule Program Date |
| 17 | TL_FORECASTED_IND | Character(1) | VARCHAR2(1) NOT NULL | Forecast Payable Time |
| 18 | TIME_RPTG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporting Type
E=Exception Time Reporting P=Positive Time Reporting |
| 19 | TL_SYSTEM_DT | Date(10) | DATE | TL System Date |
| 20 | FROMDATE | Date(10) | DATE | From Date |
| 21 | THRUDATE | Date(10) | DATE | End Date |
| 22 | USE_CURRENT_DATE | Character(1) | VARCHAR2(1) NOT NULL | Use Current Date |
| 23 | TL_PT_POI_STDT | Date(10) | DATE | Payable Time POI Start Date |
| 24 | TL_RSL_MAIN_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Run Level Statistics |
| 25 | TL_RSL_BATCH_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Batch Level Statistics |
| 26 | TL_RSL_SECT_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Program Level Statistics |
| 27 | TL_KEEP_CT | Number(4,0) | SMALLINT NOT NULL | Number Of Runs To Keep |
| 28 | KEEP_GOING | Character(1) | VARCHAR2(1) NOT NULL | Keep Going Flag for App Engine.... |
| 29 | CURRENT_END_DT | Date(10) | DATE | Current End Date |
| 30 | TL_IN_PROD | Character(1) | VARCHAR2(1) NOT NULL | This field identifies whether the application is being run in a "Production Environment", which enables and disables some features depending on the setting. Time and Labor has extensive Referential Integrity processing, which is only run when the application is being run in a Production Environment. This is done so that a customer can complete their setup work without needlessly engaging the overhead involved in this processing. Time & Labor also has a System Date feature which facilitates using a processing date which is differnt from the System Date. This can be particularly useful for system testing, but cannot be allowed in a production environment. |
| 31 | TL_TA_STARTED | Character(1) | VARCHAR2(1) NOT NULL | Started From TA Run Control |
| 32 | ALT_RUN_CTRL_ID | Character(30) | VARCHAR2(30) NOT NULL | Alternate Run Control ID |
| 33 | ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Submit Time Instance |
| 34 | TL_IPT_CT | Number(9,0) | DECIMAL(9) NOT NULL | IPT Rows Created |
| 35 | IMAGE_NUM | Number(2,0) | SMALLINT NOT NULL | Image Number |
| 36 | TABLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Table Name |
| 37 | TA_BATCH_SIZE | Number(6,0) | INTEGER NOT NULL | Max Employees In Rules Run |
| 38 | CURRENT_YEAR | Number(4,0) | SMALLINT NOT NULL | Current Year |
| 39 | PUNCH_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Count of Punch TR's in batch |
| 40 | TL_USE_RPTD_TIME | Character(1) | VARCHAR2(1) NOT NULL | Use Reported Time for POI |
| 41 | ATTENDANCE_PGM_ID | Character(10) | VARCHAR2(10) NOT NULL | Attendance Program |
| 42 | TL_ONLINE_RULES | Character(1) | VARCHAR2(1) NOT NULL | Store Online Run Statistics |
| 43 | TA_COUNTER | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 44 | TA_COUNTER1 | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 45 | TA_COUNTER2 | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 46 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 47 | TL_PAY_TIME_CT | Number(9,0) | DECIMAL(9) NOT NULL | Actual Rows Created |
| 48 | TL_FRCT_TIME_CT | Number(9,0) | DECIMAL(9) NOT NULL | Forecasted Time Row Count |
| 49 | TL_EXCEPT_CT | Number(9,0) | DECIMAL(9) NOT NULL | Exceptions Created |
| 50 | COUNTER | Signed Number(6,0) | DECIMAL(5) NOT NULL | Counter |
| 51 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Current Percent |
| 52 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 53 | TA_PCT_COUNTER2 | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 54 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 55 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 56 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 57 | ELAPSED_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Used in TL_TA_MAIN_AET |
| 58 | HOLIDAY_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Holiday Count |
| 59 | PAYABLE_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Used in TL_TA_MAIN_AET |
| 60 | TRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount H=Hours U=Units |
| 61 | TL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL | Enable Notifications |
| 62 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 63 | TL_CONTINUE_TA | Character(1) | VARCHAR2(1) NOT NULL |
Continue with Exceptions
Y/N Table Edit |
| 64 | TL_AM_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Absence Exist? |
| 65 | TL_EXCEPTION | Character(1) | VARCHAR2(1) NOT NULL | Exception Generated |
| 66 | INCL_ALL_EMPL_RCD | Character(1) | VARCHAR2(1) NOT NULL | Include All Jobs |
| 67 | TL_APRV_RETRO | Character(1) | VARCHAR2(1) NOT NULL | Field introduced to support continuation of pre-AWE approval model for payable time. |
| 68 | TL_PAY_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Payable Time Needs Approval
B=Both Detail and Summary Page D=Detail Page Only S=Summary Page Only |
| 69 | TL_RI_CHECK | Character(1) | VARCHAR2(1) NOT NULL | Used on TL Installation options to check to continue TL Referential Integrity Check |
| 70 | PRIORITY | Number(3,0) | SMALLINT NOT NULL | Priority |
| 71 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 72 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 73 | DUR | Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 74 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 75 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 76 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 77 | TL_OPA_CHUNK_MTHS | Number(2,0) | SMALLINT NOT NULL | OPA Number of Chunking Months |
| 78 | USE_TSKPRF_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicates how to assign Task Profile ID for IPT generated by the rule in question.
If the rule does not generate IPT (it may for example generate an Exception instead, then the setting is irrelevant).
0=Use Default Task Profile 1=Use Specified Task Profile 2=Distribute Tasks Equally 3=Use Previous Row Tasks 8=Enable Selection 9=Not Applicable For Template |
| 79 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 80 | TL_OPA_RBASE_ID | Character(15) | VARCHAR2(15) NOT NULL | OPA Rule Base ID |
| 81 | TL_OPA_RULE_BASE | Character(30) | VARCHAR2(30) NOT NULL | OPA Rule Base |
| 82 | INTEGRATION_ID | Character(40) | VARCHAR2(40) NOT NULL | 3rd Prty Integr Identifier |
| 83 | TL_OPA_IND | Character(1) | VARCHAR2(1) NOT NULL | OPA Rule Indicator |