TL_RUN_RULE_GRP(SQL Table) |
Index Back |
---|---|
Time Run Control for RulesThis record is used to define the Rules, Templates and Template types for a given run control within Time & Labor. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID | |
3 | Character(12) | VARCHAR2(12) NOT NULL |
Rule ID
Prompt Table: TL_RULE_DEFN |
|
4 | Character(15) | VARCHAR2(15) NOT NULL |
Template ID
Prompt Table: TL_TMPLT_VW |
|
5 | Character(3) | VARCHAR2(3) NOT NULL |
Template Type
ACC=Accumulator APP=Approval Required ATT=Attendance CON=Consecutive Days DFL=Default DTH=Daily Threshold EXC=Exception GUA=Guaranteed Hours HOL=Holiday LIB=Library MEA=Meal MIS=Miscellaneous MSP=Missing Punch OPA=OPA Regulatory Rules PRM=Premium Zone PTR=Period Threshold SCH=Schedule Deviation SHF=Shift Premium SPC=Specific Day TSK=Task |