UPG_TL1_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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | Project Costing Business Unit |
| 4 | BUSINESS_UNIT_PF | Character(5) | VARCHAR2(5) NOT NULL | Perf Meas Business Unit |
| 5 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department Set ID |
| 6 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 7 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 8 | SETID_RESOURCE | Character(5) | VARCHAR2(5) NOT NULL | Resource Set ID |
| 9 | SETID_ACTIVITY | Character(5) | VARCHAR2(5) NOT NULL | Activity Set ID |
| 10 | INTRFC_PERF_MEAS | Character(1) | VARCHAR2(1) NOT NULL | Interface with PS EPM |
| 11 | INTRFC_PROJ_COST | Character(1) | VARCHAR2(1) NOT NULL | Interface with PS Projects |
| 12 | TEMPLATE_TYPE | 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 |
| 13 | TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Template ID |
| 14 | TL_RULE_ID | Character(12) | VARCHAR2(12) NOT NULL | Rule ID |
| 15 | LIST_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
List type for Values
0=TCD Group 1=TaskGroup 10=Company 11=Paygroup 12=Grade 13=Step 14=Punch Type 15=Employee Status 16=Employee Type 17=Attendance Violations 18=Absence Take 19=Compensatory Time Off Plan 2=Time Reporting Codes 20=Plan Type 21=Payable Status 22=Reported Status 23=Absence Status 24=Exception 25=Severity 26=Benefit Plan 27=Absence Entitlement 3=WorkGroup 4=Union Code 5=Jobcode 6=Department 7=Position number 8=Location 9=Shift |
| 16 | LIST_ID | Character(12) | VARCHAR2(12) NOT NULL | List ID |
| 17 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 18 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 19 | TL_FIELDFORMAT | Character(1) | VARCHAR2(1) NOT NULL |
Field Format. Introduced to hold the numeric FIELDTYPE values in a xlat set for user friendly selection.
It is not a true representation as it also supports the need to indicate a character value as something not to be surrounded by '' when formatted into a SQL statement in the TL AE rules building.
0=Character 2=Numeric 3=Signed Numeric 4=Date 5=Time 6=Date and Time 9=Character Without Quotes |
| 20 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 21 | FIELD_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Field Value |