TL_INSTALLATION(SQL Table) |
Index Back |
|---|---|
Installation Time & Labor TblThis record describes the Installation specific parameters used within Time and Labor. The attributes of the Time and Labor Installation table are specific initial setup items to be reviewed and entered when user is first implementing the Time and Labor module |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CALC_EST_GROSS | Character(1) | VARCHAR2(1) NOT NULL |
Calculate Estimated Gross
Y/N Table Edit Default Value: Y |
| 2 | TEST_LV_BAL | Character(2) | VARCHAR2(2) NOT NULL |
Indicates where Leave Balance validation will be done in the Time & Labor application - online, batch, both, or neither.
BA=Batch Only BO=On-line and Batch NO=None ON=On-line Only Default Value: NO |
| 3 | TEST_COMP_BAL | Character(2) | VARCHAR2(2) NOT NULL |
Indicates where Comp Time Balance checking will be done - online, batch, both or neither.
BA=Batch Only BO=On-line and Batch NO=None ON=On-line Only Default Value: NO |
| 4 | INTRFC_PROJ_COST | Character(1) | VARCHAR2(1) NOT NULL |
Interface with PS Projects
Y/N Table Edit Default Value: N |
| 5 | INTRFC_PERF_MEAS | Character(1) | VARCHAR2(1) NOT NULL |
Interface with PS EPM
Y/N Table Edit Default Value: N |
| 6 | PAYROLL_REQ_NUM | Number(6,0) | INTEGER NOT NULL | Last payroll request number. |
| 7 | LAST_SEQ_PAY_TIME | Number(9,0) | DECIMAL(9) NOT NULL | Last Seq Num in Payable Time |
| 8 | TA_BATCH_SIZE | Number(6,0) | INTEGER NOT NULL |
Max Employees In Rules Run
Default Value: 100 |
| 9 | TA_LAST_ALIAS | Character(5) | VARCHAR2(5) NOT NULL | Time Admin Last Alias |
| 10 | TA_LAST_SECTION | Number(9,0) | DECIMAL(9) NOT NULL | Time Admin Last Section |
| 11 | TA_LAST_SQL_ID | Number(9,0) | DECIMAL(9) NOT NULL | Time Admin Last Sql ID |
| 12 | 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.
Y/N Table Edit Default Value: Y |
| 13 | LAST_ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Last Submit Time Instance |
| 14 | VALID_STREAM_ID | Number(15,0) | DECIMAL(15) NOT NULL | Validation Stream ID |
| 15 | VALID_INST_ID | Number(15,0) | DECIMAL(15) NOT NULL | Validation Instance |
| 16 | FILE_OUTPUT_DIR | Character(127) | VARCHAR2(127) NOT NULL | Output Directory Name for Flat File Interfaces. |
| 17 | FILE_ARCHIVE_DIR | Character(127) | VARCHAR2(127) NOT NULL | Archive Directory Name for Flat File Interfaces. |
| 18 | CALL_TA | Character(1) | VARCHAR2(1) NOT NULL |
Used in the TL_AGG_MAIN_AET state record to communicate that Rules should be run after the Aggregate Update process.
0=Don't Automatically Run Rules 1=Automatically Run Rules Default Value: 0 |
| 19 | USE_DFLT_WORKGROUP | Character(1) | VARCHAR2(1) NOT NULL |
This field is used on TL Installation Panel, to speccify the Comp Time Plan assignment. If the value='Y' - Default from Workgroup, if N- Individual assignment.
Y/N Table Edit Default Value: Y |
| 20 | VALID_SET_ID | Character(10) | VARCHAR2(10) NOT NULL |
Validation Set
Default Value: ST_ALL Prompt Table: TL_VALID_SET |
| 21 | RUN_ONLINE_RULES | Character(1) | VARCHAR2(1) NOT NULL |
Run On-line Rules
Y/N Table Edit Default Value: N |
| 22 | MAX_ONLINE_RULES | Number(3,0) | SMALLINT NOT NULL |
Maximum On-line Rules
Default Value: 0 |
| 23 | IDENTITY_COL_USED | Character(1) | VARCHAR2(1) NOT NULL |
Flag indicates if Identify Column approach used for DB2 OS390
Y/N Table Edit Default Value: N |
| 24 | PERIOD_MONTH | Signed Number(6,0) | DECIMAL(5) NOT NULL |
Number of Months to Process
Default Value: 2 |
| 25 | LEAVE_VAL_ASOF | Character(1) | VARCHAR2(1) NOT NULL | Field used in T&L Installation |
| 26 | NO_PAY_ROWS | Character(1) | VARCHAR2(1) NOT NULL |
Publish unmapped TRC as No Pay
Y/N Table Edit Default Value: N |
| 27 | AUTOPOP_TL | Character(1) | VARCHAR2(1) NOT NULL |
Auto Populate
N=Prompt for Results Y=Auto Populate Results Default Value: Y |
| 28 | COLLAPSE_CRITERIA | Character(1) | VARCHAR2(1) NOT NULL |
Collapse Criteria
N=Expand Criteria Y=Collapse Criteria Default Value: N |
| 29 | INCL_ML_BRK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include in Totals
1=Exclude Meals and Breaks 2=Include Meals 3=Include Breaks 4=Include Breaks and Meals Default Value: 3 |
| 30 | TIME_SUMMARY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Show TRC Category on Timesheet
Y/N Table Edit Default Value: N |
| 31 | TL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
Email Notifications
Y/N Table Edit Default Value: N |
| 32 | TL_EE_PAY_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Payable Time Was Approved
Y/N Table Edit Default Value: N |
| 33 | TL_EE_RPT_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Reported Time Was Approved
Y/N Table Edit Default Value: N |
| 34 | TL_EE_RPT_DENY | Character(1) | VARCHAR2(1) NOT NULL |
Reported Time Was Denied
Y/N Table Edit Default Value: N |
| 35 | TL_EE_RPT_OVRD | Character(1) | VARCHAR2(1) NOT NULL |
Reported Time Was Modified
Y/N Table Edit Default Value: N |
| 36 | TL_PAY_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Payable Time Needs Approval
Y/N Table Edit Default Value: N |
| 37 | TL_RPT_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Reported Time Needs Approval
Y/N Table Edit Default Value: N |
| 38 | TL_SCHED_EVENT | Character(1) | VARCHAR2(1) NOT NULL |
Scheduled Event Modified
Y/N Table Edit Default Value: N |
| 39 | TL_EXCEPTION | Character(1) | VARCHAR2(1) NOT NULL |
Exception Generated
Y/N Table Edit Default Value: N |
| 40 | TL_RI_CHECK | Character(1) | VARCHAR2(1) NOT NULL |
Used on TL Installation options to check to continue TL Referential Integrity Check
Y/N Table Edit |
| 41 | TL_CONTINUE_TA | Character(1) | VARCHAR2(1) NOT NULL |
Continue with Exceptions
Y/N Table Edit Default Value: Y |
| 42 | INCL_ALL_EMPL_RCD | Character(1) | VARCHAR2(1) NOT NULL |
Include Multiple Jobs
Y/N Table Edit Default Value: Y |
| 43 | SCHED_RESOLUTION | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Resolution Options
1=Take Last Schedule Update 2=Take Online Override Default Value: 1 |
| 44 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL |
Decimal Positions
Default Value: 2 |
| 45 | TL_CF_VALIDATE | Character(1) | VARCHAR2(1) NOT NULL |
Chartfields Validation Flag
N=None S=Sync Message T=Table Validation Default Value: T |
| 46 | TL_PRIOR_PAYGROUP | Character(1) | VARCHAR2(1) NOT NULL |
Prior Paygroup Processing
Y/N Table Edit Default Value: Y |
| 47 | ENFORCE_TR_TMPLT | Character(1) | VARCHAR2(1) NOT NULL |
Show all Time Reporting Fields
Y/N Table Edit Default Value: N |
| 48 | TL_REGEN_WRKHRS | Character(1) | VARCHAR2(1) NOT NULL |
Regenerate Reproted time at Installation level
Y/N Table Edit Default Value: N |
| 49 | ALLW_CONC_LOADTL | Character(1) | VARCHAR2(1) NOT NULL |
Allow Concurrent Run Control
Y/N Table Edit Default Value: Y |
| 50 | LOAD_PRCS_RETAIN | Number(3,0) | SMALLINT NOT NULL |
Retain
Default Value: 1 |
| 51 | TL_IG_RP_PNA | Character(1) | VARCHAR2(1) NOT NULL |
Ignore Payable time Rows for PNA
Y/N Table Edit Default Value: Y |