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_PERF_MEAS | Character(1) | VARCHAR2(1) NOT NULL |
Interface with PS EPM
Y/N Table Edit Default Value: N |
| 5 | PAYROLL_REQ_NUM | Number(6,0) | INTEGER NOT NULL | Last payroll request number. |
| 6 | LAST_SEQ_PAY_TIME | Number(9,0) | DECIMAL(9) NOT NULL | Last Seq Num in Payable Time |
| 7 | TA_BATCH_SIZE | Number(6,0) | INTEGER NOT NULL |
Max Employees In Rules Run
Default Value: 100 |
| 8 | 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 |
| 9 | LAST_ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Last Submit Time Instance |
| 10 | FILE_OUTPUT_DIR | Character(127) | VARCHAR2(127) NOT NULL | Output Directory Name for Flat File Interfaces. |
| 11 | FILE_ARCHIVE_DIR | Character(127) | VARCHAR2(127) NOT NULL | Archive Directory Name for Flat File Interfaces. |
| 12 | 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 Default Value: 0 |
| 13 | 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 |
| 14 | VALID_SET_ID | Character(10) | VARCHAR2(10) NOT NULL |
Validation Set
Default Value: ST_ALL Prompt Table: TL_VALID_SET |
| 15 | RUN_ONLINE_RULES | Character(1) | VARCHAR2(1) NOT NULL |
Real Time Rules
N=Real Time Rules Not Enabled S=Run from Submit button Y=Run from Apply Rules button Default Value: N |
| 16 | MAX_ONLINE_RULES | Number(3,0) | SMALLINT NOT NULL |
Maximum Time (in Months)
Default Value: 0 |
| 17 | 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 |
| 18 | PERIOD_MONTH | Signed Number(6,0) | DECIMAL(5) NOT NULL |
Number of Months to Process
Default Value: 2 |
| 19 | NO_PAY_ROWS | Character(1) | VARCHAR2(1) NOT NULL |
Publish unmapped TRC as No Pay
Y/N Table Edit Default Value: N |
| 20 | AUTOPOP_TL | Character(1) | VARCHAR2(1) NOT NULL |
Loading of Matching Employees
N=Prompt for Results Y=Auto Populate Results Default Value: Y |
| 21 | COLLAPSE_CRITERIA | Character(1) | VARCHAR2(1) NOT NULL |
Default Criteria Presentation
N=Show Criteria List Expanded Y=Show Criteria List Collapsed Default Value: N |
| 22 | INCL_ML_BRK_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Totaling
1=Exclude Breaks and Meals 2=Include Meals 3=Include Breaks 4=Include Breaks and Meals Default Value: 3 |
| 23 | TIME_SUMMARY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Show TRC Category on Timesheet
Y/N Table Edit Default Value: N |
| 24 | TL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
Enable Notifications
Y/N Table Edit Default Value: N |
| 25 | TL_EE_PAY_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Payable Time Is Approved
Y/N Table Edit Default Value: N |
| 26 | 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 Y/N Table Edit Default Value: N |
| 27 | TL_SCHED_EVENT | Character(1) | VARCHAR2(1) NOT NULL |
Scheduled Event Modified
Y/N Table Edit Default Value: N |
| 28 | TL_EXCEPTION | Character(1) | VARCHAR2(1) NOT NULL |
Exception Generated
Y/N Table Edit Default Value: N |
| 29 | 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 Default Value: Y |
| 30 | TL_CONTINUE_TA | Character(1) | VARCHAR2(1) NOT NULL |
Continue with Exceptions
Y/N Table Edit Default Value: Y |
| 31 | INCL_ALL_EMPL_RCD | Character(1) | VARCHAR2(1) NOT NULL |
Include All Jobs
Y/N Table Edit Default Value: Y |
| 32 | SCHED_RESOLUTION | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Resolution
1=Take Last Schedule Update 2=Take Online Override Default Value: 1 |
| 33 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL |
Decimal Positions
Default Value: 2 |
| 34 | TL_CF_VALIDATE | Character(1) | VARCHAR2(1) NOT NULL |
Chartfields Validation Flag
N=None S=Sync Message T=Table Validation Default Value: T |
| 35 | TL_PRIOR_PAYGROUP | Character(1) | VARCHAR2(1) NOT NULL |
Prior Paygroup Processing
Y/N Table Edit Default Value: Y |
| 36 | ENFORCE_TR_TMPLT | Character(1) | VARCHAR2(1) NOT NULL |
Show all Time Reporting Fields
Y/N Table Edit Default Value: N |
| 37 | OVERRIDE_OWS_SCH | Character(1) | VARCHAR2(1) NOT NULL |
Field used to indicate whether T&L Schedule Info is allowed / used to override information in other connected product.
Y/N Table Edit Default Value: N |
| 38 | TL_REGEN_WRKHRS | Character(1) | VARCHAR2(1) NOT NULL |
Regenerate Reproted time at Installation level
Y/N Table Edit Default Value: N |
| 39 | ALLW_CONC_LOADTL | Character(1) | VARCHAR2(1) NOT NULL |
Allow Concurrent Run Control
Y/N Table Edit Default Value: Y |
| 40 | LOAD_PRCS_RETAIN | Number(3,0) | SMALLINT NOT NULL |
Retain
Default Value: 1 |
| 41 | TL_IG_RP_PNA | Character(1) | VARCHAR2(1) NOT NULL |
Ignore Payable time Rows for PNA
Y/N Table Edit Default Value: Y |
| 42 | TL_ST_BATCH_SIZE | Number(9,0) | DECIMAL(9) NOT NULL |
Field introduced to configure the size of batches of incoming Punches from TCD in the TL_ST_LD_DMN AE process.
Default Value: 2000 |
| 43 | ALLOW_TS_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
Indicator field introduced for controlling managers access to employees timesheet.
Y/N Table Edit Default Value: Y |
| 44 | TL_APRV_RETRO | Character(1) | VARCHAR2(1) NOT NULL |
Field introduced to support continuation of pre-AWE approval model for payable time.
Y/N Table Edit Default Value: N |
| 45 | TL_EE_PAY_DENIED | Character(1) | VARCHAR2(1) NOT NULL |
Field introduced to allow configuring whether or not to electronically notify time reporter when payable time is denied
Y/N Table Edit Default Value: N |
| 46 | TL_PG_TSS_RT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Realtime Processing
D=Use Installation Default N=No Realtime Processing Y=Allow Realtime Processing |
| 47 | TL_PG_TSS_DAYSFWD | Number(4,0) | SMALLINT NOT NULL | number of days forward to report |
| 48 | TL_PG_TSS_DAYSBCK | Number(4,0) | SMALLINT NOT NULL | Number of days back to report |
| 49 | TL_SM_STATS | Number(15,0) | DECIMAL(15) NOT NULL | Smart Update Stats Threshold |
| 50 | TL_SM_PURGE | Number(15,0) | DECIMAL(15) NOT NULL | Smart Delete Threshold |
| 51 | TL_ALRT_EMP_NOT | Character(1) | VARCHAR2(1) NOT NULL |
Enable Alert Notification
Y/N Table Edit Default Value: N |
| 52 | TRC_DESCR_FLU_FLG | Character(1) | VARCHAR2(1) NOT NULL |
TRC Presentations
C=CODE - Description D=Description - CODE O=Description Default Value: O |
| 53 | TRC_DESCR_FLG_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to allow user to override TRC presentation
Y/N Table Edit Default Value: Y |
| 54 | TIME_PREPOP | Character(1) | VARCHAR2(1) NOT NULL |
Time Prepopulation Method
0=Off 1=Prior Period 2=Schedule 3=Task Values Default Value: 0 |
| 55 | TIME_PREPOP_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Allow user override time prepopulation method
Y/N Table Edit Default Value: Y |
| 56 | START_DAY_OF_WEEK | Character(1) | VARCHAR2(1) NOT NULL |
Start Day of Week
1=1 - Monday 2=2 - Tuesday 3=3 - Wednesday 4=4 - Thursday 5=5 - Friday 6=6 - Saturday 7=7 - Sunday Default Value: 1 |
| 57 | START_DAY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Allow user to override start day of the week
Y/N Table Edit Default Value: Y |
| 58 | TL_SORT | Character(1) | VARCHAR2(1) NOT NULL |
Sort Indicator
A=Ascending D=Descending Default Value: D |
| 59 | TL_SORT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Allow user to override sorting of punch history
Y/N Table Edit Default Value: Y |
| 60 | TL_DETAIL | Character(1) | VARCHAR2(1) NOT NULL |
Time Details option User Preference
C=Collapsed E=Expanded Default Value: C |
| 61 | TL_DETAIL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Override Details Setting
Y/N Table Edit Default Value: Y |
| 62 | TL_GPS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
GPS Location Service
Y/N Table Edit Default Value: N |
| 63 | TL_GROUP_LOC | Number(10,0) | DECIMAL(10) NOT NULL |
Group Employee location
Default Value: 500 |
| 64 | TL_AENRL_ENABLE | Character(1) | VARCHAR2(1) NOT NULL |
Enable Auto Enrollment
Y/N Table Edit Default Value: N |
| 65 | TL_EARLY_IN | Character(1) | VARCHAR2(1) NOT NULL | Employee Presence - Early In |
| 66 | TL_EARLY_OUT | Character(1) | VARCHAR2(1) NOT NULL | Employee Presence- Early Out |
| 67 | TL_LATE_IN | Character(1) | VARCHAR2(1) NOT NULL | Employee Presence - Late In |
| 68 | TL_LATE_OUT | Character(1) | VARCHAR2(1) NOT NULL | Employee Presence - Late Out |
| 69 | TL_MEAL_PUNCH | Character(1) | VARCHAR2(1) NOT NULL | Employee Presence - Meal |
| 70 | TL_TOLERANCE | Number(3,0) | SMALLINT NOT NULL | Schedule Deviation Tolerance |
| 71 | TL_TIME_TOTAL | Character(1) | VARCHAR2(1) NOT NULL |
Time Totalling
E=Exclude Meal I=Include Meal Default Value: I |
| 72 | TL_TRN_TRC_LIST | Character(12) | VARCHAR2(12) NOT NULL |
Training TRC list for Workforce Analytics
Prompt Table: TL_VAL_LIST_VW1 |
| 73 | TL_ABS_GENPAY_TIME | Character(1) | VARCHAR2(1) NOT NULL |
This field is used in TL_INSTALLATION for the feature related to TL-Absence integration to signify whether the absence payable time required or not
Y/N Table Edit Default Value: N |
| 74 | TL_TIME_UNIT | Character(1) | VARCHAR2(1) NOT NULL |
Default Time Units values
Q=Report Time in Quantity T=Report Time in Units Default Value: Q |
| 75 | TL_TIME_STATUS_BAR | Character(1) | VARCHAR2(1) NOT NULL |
Reported Time Status Bar option
N=No Y=Yes Default Value: Y |
| 76 | TL_USE_QF | Character(1) | VARCHAR2(1) NOT NULL |
Use Quick-Fill for Time Details
Y/N Table Edit Default Value: N |
| 77 | OVRD_COLOR_PREF | Character(1) | VARCHAR2(1) NOT NULL |
Override User color preference
Y/N Table Edit Default Value: N |
| 78 | SCH_BACKGROUND_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Scheduled Time background Type
C=Color Code P=Pattern S=Solid Color Default Value: S |
| 79 | SCH_BACKGROUND | Character(30) | VARCHAR2(30) NOT NULL |
Schedule time background
Default Value: RED |
| 80 | REP_BACKGROUND_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Scheduled Time background Type
C=Color Code P=Pattern S=Solid Color Default Value: S |
| 81 | REP_BACKGROUND | Character(30) | VARCHAR2(30) NOT NULL |
reporting time background
Default Value: GRN |
| 82 | OVT_BACKGROUND_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Overtime background Option
C=Color Code P=Pattern S=Solid Color Default Value: P |
| 83 | OVT_BACKGROUND | Character(30) | VARCHAR2(30) NOT NULL |
Overtime background
Default Value: PS_OVT_PATRN_S_FL |
| 84 | TL_SCH_CHG_LIMIT | Number(3,0) | SMALLINT NOT NULL | Schedule Change Limit (Days) |
| 85 | TL_TR_ATTESTATION | Character(1) | VARCHAR2(1) NOT NULL |
Attestation for time reporting
Y/N Table Edit Default Value: N |
| 86 | TL_MGR_AUTO_APPR | Character(1) | VARCHAR2(1) NOT NULL |
New field to use in Manager auto approval feature
Default Value: N |
| 87 | TL_ON_ENTRY_UPDATE | Character(1) | VARCHAR2(1) NOT NULL |
Update Reported Hours on Entry Option
Y/N Table Edit Default Value: Y |
| 88 | TL_EXPAND_TIME_DTL | Character(1) | VARCHAR2(1) NOT NULL |
Expand time details on Timesheet. This flag would show all the fields of time details if ON. Otherwise it will show Time details button
Y/N Table Edit Default Value: N |
| 89 | TL_ABS_APPROVAL_ID | Character(1) | VARCHAR2(1) NOT NULL |
Request Absence on Fluid Timesheet. This flag would decide whther the Absence submitted should be routed based on TL approval process or Absence Approval Process
Y/N Table Edit Default Value: N |
| 90 | EFFDT_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Use Effective Dated Value List
Y/N Table Edit Default Value: N |
| 91 | TL_SEPARATE_AWE | Character(1) | VARCHAR2(1) NOT NULL |
Indicator to separate AWE processing from Time Admin in Batch only, Batch and Onlien/or not at all.
B=Batch Only N=Normal AWE Processing O=Use for both Online and Batch Default Value: N |
| 92 | TL_CONCURRENT_AWE | Number(6,0) | INTEGER NOT NULL |
Number of employees per AWE process.
Default Value: 0 |
| 93 | TL_SHOW_PEER_CAL | Character(1) | VARCHAR2(1) NOT NULL |
Show Peer Calendar
Y/N Table Edit Default Value: Y |
| 94 | TL_SHOW_QF_CAL | Character(1) | VARCHAR2(1) NOT NULL |
Show Quick Filters
Y/N Table Edit Default Value: Y |
| 95 | TRANSACTION_NBR | Number(15,0) | DECIMAL(15) NOT NULL |
08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
Default Value: 0 |
| 96 | TL_SHOW_TS_BY_WEEK | Character(1) | VARCHAR2(1) NOT NULL |
Show Elapsed Timesheet by Week
Y/N Table Edit Default Value: Y |
| 97 | TL_PAY_INCR_SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Payable Incremental Search
Y/N Table Edit Default Value: N |