TL_TA_RULES_OVR

(SQL Table)
Index Back

Time Admin Work Table

Time Admin Work Table to hold the overrides

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 PUNCH_TYPE Character(2) VARCHAR2(2) NOT NULL Global Punch Types
0=Elapsed
1=In
2=Out
3=Meal
4=Break
5=Transfer
6 PUNCH_BEGIN DateTime(26) TIMESTAMP Punch In
7 PUNCH_BEGIN_R DateTime(26) TIMESTAMP Punch In Rounded
8 TIME_IN_MIN1 Number(4,0) SMALLINT NOT NULL Minutes From Midnight
9 PUNCH_END DateTime(26) TIMESTAMP Punch out
10 PUNCH_END_R DateTime(26) TIMESTAMP Punch In Rounded
11 TIME_IN_MIN2 Number(4,0) SMALLINT NOT NULL Minutes From Midnight
12 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone
13 TIMEZONE2 Character(9) VARCHAR2(9) NOT NULL Time Zone
14 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.
15 BADGE_ID Character(20) VARCHAR2(20) NOT NULL Badge ID
16 EST_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Gross
17 LBR_DIST_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Labor Distribution Amount
18 DILUTED_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Diluted Labor Distribution Amt
19 CURRENCY_CD1 Character(3) VARCHAR2(3) NOT NULL Currency Code
20 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
21 RULE_ELEMENT_1 Character(10) VARCHAR2(10) NOT NULL Rule Element 1
22 RULE_ELEMENT_2 Character(10) VARCHAR2(10) NOT NULL Rule Element 2
23 RULE_ELEMENT_3 Character(10) VARCHAR2(10) NOT NULL Rule Element 3
24 RULE_ELEMENT_4 Character(10) VARCHAR2(10) NOT NULL Rule Element 4
25 RULE_ELEMENT_5 Character(10) VARCHAR2(10) NOT NULL Rule Element 5
26 RULE_FLAG1 Number(1,0) SMALLINT NOT NULL Rule Flag
27 RULE_FLAG2 Number(1,0) SMALLINT NOT NULL Rule Flag
28 RULE_FLAG3 Number(1,0) SMALLINT NOT NULL Rule Flag
29 RULE_FLAG4 Number(15,0) DECIMAL(15) NOT NULL Rule Flag
30 RULE_FLAG5 Number(19,6) DECIMAL(18,6) NOT NULL Rule Flag
31 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
32 DFLT_TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
33 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
34 DFLT_TASK_PROF_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID
35 DFLT_TASKTMPL_ID Character(10) VARCHAR2(10) NOT NULL Task Profile Template ID
36 PERIOD_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Sequence Number
37 PERIOD_SEQUENCE Number(10,0) DECIMAL(10) NOT NULL Sequence Number of Period ID
38 PAYABLE_STATUS Character(2) VARCHAR2(2) NOT NULL Payable Status
AP=Approved
CL=Closed
DL=Diluted
ES=Estimated
IG=Ignore
NA=Needs Approval
NP=No Pay
OE=Online Estimate
PD=Distributed
RP=Rejected by Payroll
RV=Reversed Check
SP=Sent to Payroll
TP=Taken by Payroll
39 IN_BATCH Character(1) VARCHAR2(1) NOT NULL In_Batch
40 OFFDAY_IND Character(1) VARCHAR2(1) NOT NULL Off Day Indicator
N=Work Shift
Y=Off Shift

Y/N Table Edit

41 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor

Prompt Table: TL_TRC_TBL

42 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL This field represents the measure of Work in hrs,amount etc.,
43 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

44 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

45 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

46 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

Prompt Table: LOCAL_TAX_TBL

47 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code

Prompt Table: COMP_RT_REG_VW

48 BILLABLE_IND Character(1) VARCHAR2(1) NOT NULL Billable Indicator
N=No
Y=Yes

Y/N Table Edit

Default Value: N

49 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate.
50 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

51 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: TL_BUS_UNIT_VW

52 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
53 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: TL_LOCATION_VW

54 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
55 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: TL_DEPT_TBL_VW

56 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID
57 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

Prompt Table: TL_JOBCODE_VW

58 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Prompt Table: POSITION_DATA

59 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product

Prompt Table: TL_PRODUCT_TBL

60 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer

Prompt Table: TL_CUSTOMER

61 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code
62 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
63 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Meas Business Unit

Prompt Table: BUS_UNIT_TBL_PF

64 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project/Grant
65 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID
66 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
67 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Resource Type

Prompt Table: TL_PROJ_RTYPE_V

68 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID
69 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Resource Category
70 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Resource Sub Category
71 TASK Character(5) VARCHAR2(5) NOT NULL Task

Prompt Table: TL_TASK

72 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1

Prompt Table: TL_USER_FIELD_1

73 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2

Prompt Table: TL_USER_FIELD_2

74 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3

Prompt Table: TL_USER_FIELD_3

75 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4

Prompt Table: TL_USER_FIELD_4

76 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5

Prompt Table: TL_USER_FIELD_5

77 TL_RULE_ID Character(12) VARCHAR2(12) NOT NULL Rule ID
78 ORIG_TRC Character(5) VARCHAR2(5) NOT NULL Original Time Rptg Cd
79 ORIG_TL_QTY Number(19,6) DECIMAL(18,6) NOT NULL Original TL Quantity used in rules processing.
80 RT_SOURCE Character(3) VARCHAR2(3) NOT NULL Reported Time Source. the originator of Reported Time
AM=Absence Management
MD=Mobile Device
ONL=Online
SCH=Schedule Source
SYS=Time and Labor System
TCD=Time Collection Device
81 PAY_SYSTEM_FLG Character(2) VARCHAR2(2) NOT NULL Payroll System
GP=Global Payroll
NA=Payroll for North America
OT=Other
PI=Payroll Interface
82 ORIG_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original Sequence Number
83 INITIAL_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original sequence number of payable time row.