TL_TA_MAIN_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 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 3 | AE_PROGRAM | Character(12) | VARCHAR2(12) NOT NULL | Clear in Program |
| 4 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 5 | ATTENDANCE_PGM_ID | Character(10) | VARCHAR2(10) NOT NULL | Attendance Program |
| 6 | BATCH_NUM | Number(4,0) | SMALLINT NOT NULL | Batch Number |
| 7 | CALC_ALL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate that ALL TR's should be processed, regardless of their TA_STATUS flag in the TR_STATUS table.
N=No, do not Calculate All Y=Yes, Calulate All Y/N Table Edit Default Value: N |
| 8 | CALL_TA | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the TA process should be run as a direct extension at the end of the Submit Time process.
With the introduction of the option of subjecting reported time to approval, this may in cases no longer be a viable option.
0=Don't Automatically Run Rules 1=Automatically Run Rules |
| 9 | COUNTER | Signed Number(6,0) | DECIMAL(5) NOT NULL | Counter |
| 10 | CURRENT_END_DT | Date(10) | DATE | Current End Date |
| 11 | CURRENT_YEAR | Number(4,0) | SMALLINT NOT NULL | Current Year |
| 12 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 13 | DBVALUE | Character(10) | VARCHAR2(10) NOT NULL | Database Value |
| 14 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 15 | 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. |
| 16 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 17 | ELAPSED_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Used in TL_TA_MAIN_AET |
| 18 | FROMDATE | Date(10) | DATE | From Date |
| 19 | HGA | Character(1) | VARCHAR2(1) NOT NULL | Global Absence Flag |
| 20 | HOLIDAY_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Holiday Count |
| 21 | INCL_ALL_EMPL_RCD | Character(1) | VARCHAR2(1) NOT NULL | Include All Jobs |
| 22 | KEEP_GOING | Character(1) | VARCHAR2(1) NOT NULL | Keep Going Flag for App Engine.... |
| 23 | LAST_SEQ_PAY_TIME | Number(9,0) | DECIMAL(9) NOT NULL | Last Seq Num in Payable Time |
| 24 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 25 | PAYABLE_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Used in TL_TA_MAIN_AET |
| 26 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Current Percent |
| 27 | POI_START_DT | Date(10) | DATE | Period of Interest Start |
| 28 | POI_END_DT | Date(10) | DATE | Period of Interest End |
| 29 | PUNCH_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Count of Punch TR's in batch |
| 30 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 31 | ROUNDING_OPTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Governs the rounding scheme for post-rule rounding in the TA process.
D=Round By Day N=No Rounding S=Round Each Entry |
| 32 | RULE_PGM_ID | Character(12) | VARCHAR2(12) NOT NULL | Rule Program ID |
| 33 | RULEPGM_EFFDT | Date(10) | DATE | Rule Program Date |
| 34 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 35 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 36 | ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Submit Time Instance |
| 37 | STORE_BTCH_INFO | Character(1) | VARCHAR2(1) NOT NULL |
Store EE Level Statistics
Y/N Table Edit |
| 38 | STORE_RULE_MAP | Character(1) | VARCHAR2(1) NOT NULL |
Store Rule Level Statistics
Y/N Table Edit |
| 39 | TA_BATCH_SIZE | Number(6,0) | INTEGER NOT NULL | Max Employees In Rules Run |
| 40 | TA_COUNTER | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 41 | TA_COUNTER2 | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 42 | TABLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Table Name |
| 43 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 44 | THRUDATE | Date(10) | DATE | End Date |
| 45 | TIME_RPTG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporting Type
E=Exception Time Reporting P=Positive Time Reporting |
| 46 | TL_AM_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Absence Exist? |
| 47 | TL_APRV_RETRO | Character(1) | VARCHAR2(1) NOT NULL | Field introduced to support continuation of pre-AWE approval model for payable time. |
| 48 | TL_CONTINUE_TA | Character(1) | VARCHAR2(1) NOT NULL |
Continue with Exceptions
Y/N Table Edit |
| 49 | TL_EXCEPTION | Character(1) | VARCHAR2(1) NOT NULL | Exception Generated |
| 50 | TL_EXCEPT_CT | Number(9,0) | DECIMAL(9) NOT NULL | Exceptions Created |
| 51 | TL_FORECASTED_IND | Character(1) | VARCHAR2(1) NOT NULL | Forecast Payable Time |
| 52 | 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. |
| 53 | TL_IPT_CT | Number(9,0) | DECIMAL(9) NOT NULL | IPT Rows Created |
| 54 | TL_KEEP_CT | Number(4,0) | SMALLINT NOT NULL | Number Of Runs To Keep |
| 55 | TL_ONLINE_RULES | Character(1) | VARCHAR2(1) NOT NULL | Store Online Run Statistics |
| 56 | 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 |
| 57 | TL_PAY_TIME_CT | Number(9,0) | DECIMAL(9) NOT NULL | Actual Rows Created |
| 58 | TL_RI_CHECK | Character(1) | VARCHAR2(1) NOT NULL | Used on TL Installation options to check to continue TL Referential Integrity Check |
| 59 | TL_RSL_MAIN_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Run Level Statistics |
| 60 | TL_RSL_BATCH_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Batch Level Statistics |
| 61 | TL_RSL_SECT_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Program Level Statistics |
| 62 | TL_SYSTEM_DT | Date(10) | DATE | TL System Date |
| 63 | TL_TA_MODE | Character(2) | VARCHAR2(2) NOT NULL |
Single field indicating the mode in which the TA process is being run. Used to control the processing flow.
BF=Batch Forecast BR=Batch Regular Calculation OF=Online Forecast OR=Online Regular Calculation |
| 64 | TL_USE_RPTD_TIME | Character(1) | VARCHAR2(1) NOT NULL | Use Reported Time for POI |
| 65 | TL_SM_STATS | Number(15,0) | DECIMAL(15) NOT NULL | Smart Update Stats Threshold |
| 66 | TL_STATS_GATHER | Number(5,0) | INTEGER NOT NULL | Count of %UpdateStats Skipped |
| 67 | TL_SM_TRUNC | Number(5,0) | INTEGER NOT NULL | No. of Truncates Skipped |
| 68 | TRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount H=Hours U=Units |
| 69 | USE_CURRENT_DATE | Character(1) | VARCHAR2(1) NOT NULL | Use Current Date |
| 70 | VALID_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Validation Set |
| 71 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 72 | WRKGRP_EFFDT | Date(10) | DATE | Workgroup Effective Date |