TL_TA_MAIN_AET(SQL Table) |
Index Back |
|---|
| # | 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 | App Enging Program Name |
| 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_RPGM_PRFL | Character(1) | VARCHAR2(1) NOT NULL |
Store the Rule Program Profile
Y/N Table Edit |
| 12 | STORE_RNTM_MSGS | Character(1) | VARCHAR2(1) NOT NULL |
Store the Runtime Messages?
Y/N Table Edit |
| 13 | STORE_RULE_MAP | Character(1) | VARCHAR2(1) NOT NULL |
Store Copies of the Rule Map
Y/N Table Edit |
| 14 | STORE_RULE_TIMING | Character(1) | VARCHAR2(1) NOT NULL |
Store the Rule Timings?
Y/N Table Edit |
| 15 | STORE_BTCH_INFO | Character(1) | VARCHAR2(1) NOT NULL |
Store Copies of the Batches
Y/N Table Edit |
| 16 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 17 | WRKGRP_EFFDT | Date(10) | DATE | Effective Date from WRKGRP_TBL |
| 18 | RULE_PGM_ID | Character(12) | VARCHAR2(12) NOT NULL | Rule Program ID |
| 19 | RULEPGM_EFFDT | Date(10) | DATE | Effective Date from RULE_PGM |
| 20 | 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 |
| 21 | TL_FORECASTED_IND | Character(1) | VARCHAR2(1) NOT NULL | Forecast Payable Time |
| 22 | TIME_RPTG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporting Type
E=Exception Time Reporting P=Positive Time Reporting |
| 23 | TL_SYSTEM_DT | Date(10) | DATE | TL System Date |
| 24 | FROMDATE | Date(10) | DATE | From Date |
| 25 | THRUDATE | Date(10) | DATE | End Date |
| 26 | USE_CURRENT_DATE | Character(1) | VARCHAR2(1) NOT NULL | Use Current Date |
| 27 | TL_PT_POI_STDT | Date(10) | DATE | Payable Time POI Start Date |
| 28 | TL_RSL_MAIN_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Macro Time Admin Stats |
| 29 | TL_RSL_BATCH_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Batch Stats |
| 30 | TL_RSL_SECT_IND | Character(1) | VARCHAR2(1) NOT NULL | Store Section Stats |
| 31 | TL_KEEP_CT | Number(2,0) | SMALLINT NOT NULL | Keep Last (n) Time Admin Runs |
| 32 | KEEP_GOING | Character(1) | VARCHAR2(1) NOT NULL | Keep Going Flag for App Engine.... |
| 33 | CURRENT_END_DT | Date(10) | DATE | Current End Date |
| 34 | 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. |
| 35 | TL_TA_STARTED | Character(1) | VARCHAR2(1) NOT NULL | Started From TA Run Control |
| 36 | ALT_RUN_CTRL_ID | Character(30) | VARCHAR2(30) NOT NULL | Alternate Run Control ID |
| 37 | ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Session Number |
| 38 | TL_IPT_CT | Number(9,0) | DECIMAL(9) NOT NULL | IPT Row Count |
| 39 | IMAGE_NUM | Number(2,0) | SMALLINT NOT NULL | Image Number |
| 40 | TABLE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Table Name |
| 41 | TA_BATCH_SIZE | Number(6,0) | INTEGER NOT NULL | Max Employees In Rules Run |
| 42 | CURRENT_YEAR | Number(4,0) | SMALLINT NOT NULL | Current Year |
| 43 | PUNCH_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Count of Punch TR's in batch |
| 44 | TL_USE_RPTD_TIME | Character(1) | VARCHAR2(1) NOT NULL | Use Reported Time for POI |
| 45 | ATTENDANCE_PGM_ID | Character(10) | VARCHAR2(10) NOT NULL | Attendance Program |
| 46 | TL_ONLINE_RULES | Character(1) | VARCHAR2(1) NOT NULL | T&&L Online Rules |
| 47 | TA_COUNTER | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 48 | TA_COUNTER1 | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 49 | TA_COUNTER2 | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 50 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 51 | DDLSPACENAME | Character(30) | VARCHAR2(30) NOT NULL | Tablespace Name |
| 52 | TL_PAY_TIME_CT | Number(9,0) | DECIMAL(9) NOT NULL | Payable Time Row Count |
| 53 | TL_FRCT_TIME_CT | Number(9,0) | DECIMAL(9) NOT NULL | Forecasted Time Row Count |
| 54 | TL_EXCEPT_CT | Number(9,0) | DECIMAL(9) NOT NULL | Exceptions Row Count |
| 55 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 56 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Current Percent |
| 57 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 58 | TA_PCT_COUNTER | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 59 | TA_PCT_COUNTER1 | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 60 | TA_PCT_COUNTER2 | Number(15,0) | DECIMAL(15) NOT NULL | TA COUNTER |
| 61 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
| 62 | EXIST | Character(1) | VARCHAR2(1) NOT NULL | Currency Exist |
| 63 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 64 | ELAPSED_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Used in TL_TA_MAIN_AET |
| 65 | HOLIDAY_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | Holiday Count |
| 66 | PAYABLE_COUNT | Number(12,0) | DECIMAL(12) NOT NULL | Used in TL_TA_MAIN_AET |
| 67 | TRC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount H=Hours U=Units |
| 68 | TL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL | Email Notifications |
| 69 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 70 | TL_CONTINUE_TA | Character(1) | VARCHAR2(1) NOT NULL |
Continue with Exceptions
Y/N Table Edit |
| 71 | TL_AM_EXIST | Character(1) | VARCHAR2(1) NOT NULL | Absence Exist? |
| 72 | TL_EXCEPTION | Character(1) | VARCHAR2(1) NOT NULL | Exception Generated |
| 73 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 74 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 75 | DUR | Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 76 | PIN_TAKE_NUM | Number(8,0) | INTEGER NOT NULL | Absence Take |
| 77 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 78 | INCL_ALL_EMPL_RCD | Character(1) | VARCHAR2(1) NOT NULL | Include Multiple Jobs |