UPG_TL_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 | RECNAME_1 | Character(15) | VARCHAR2(15) NOT NULL | Record 1 Name |
| 3 | RECNAME_2 | Character(15) | VARCHAR2(15) NOT NULL | Record 2 Name |
| 4 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 5 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Fieldname 2 |
| 6 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 7 | AE_STEP | Character(8) | VARCHAR2(8) NOT NULL | Name |
| 8 | TEMP_PURCH_DATE | Date(10) | DATE | ESPP Temp Purchase Date |
| 9 | LAST_SEQ_PAY_TIME | Number(9,0) | DECIMAL(9) NOT NULL | Last Seq Num in Payable Time |
| 10 | NEEDS_APPR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Needs Approval |
| 11 | BUSINESS_UNIT_PF | Character(5) | VARCHAR2(5) NOT NULL | Perf Meas Business Unit |
| 12 | TSKPRF_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Task Profile Detail SeqNum |
| 13 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 14 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 15 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 16 | ALLOCATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Allocation Type
C=Allocation by Percentage E=Allocation Equally All Tasks H=Allocation by Quantity |
| 17 | SEND_TO_TCD | Character(1) | VARCHAR2(1) NOT NULL | Send To TCD |
| 18 | TASK_PRFL_TMPLT_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Template ID |
| 19 | TASKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup |
| 20 | TASK_PRF_VER | Number(3,0) | SMALLINT NOT NULL | Task Profile Version Number |
| 21 | LABOR_DIST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Labor Distribution Flag |
| 22 | RULE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Rule Flag
N=Batch Rules Not Applied X=Chgd since Batch Rules Appld Y=Batch Rules Applied |
| 23 | UPG_PARAM1 | Character(1) | VARCHAR2(1) NOT NULL | UPG_PARAM1 |
| 24 | UPG_PARAM2 | Character(1) | VARCHAR2(1) NOT NULL | UPG_PARAM2 |
| 25 | UPG_PARAM3 | Character(1) | VARCHAR2(1) NOT NULL | UPG_PARAM3 |
| 26 | UPG_PARAM_VALUE1 | Character(11) | VARCHAR2(11) NOT NULL | UPG_PARAM_VALUE1 |
| 27 | UPG_PARAM_VALUE2 | Character(11) | VARCHAR2(11) NOT NULL | UPG_PARAM_VALUE2 |
| 28 | UPG_PARAM_VALUE3 | Character(11) | VARCHAR2(11) NOT NULL | UPG_PARAM_VALUE3 |
| 29 | APPROVAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Approval Flag |
| 30 | SCHEDULE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Schedule Flag |
| 31 | REPORTED_FLAG | Character(1) | VARCHAR2(1) NOT NULL | This field is used to identify when a record has been reported to the approprirate agency. |
| 32 | GROUP_FIELD | Character(3) | VARCHAR2(3) NOT NULL |
Group Criteria Field
BAR=Bargaining Unit BUS=Business Unit COM=Company DEP=Department ECL=Employee Class EID=Employee ID ER#=Employee Record Number EST=Employee Status ETP=Employee Type FPT=Full/Part Time JCD=Jobcode LOC=Location PGP=Paygroup RTM=Regular/Temporary RTO=Reports To SID=Supervisor Id TGP=Taskgroup TST=Time Reporting Status UCD=Union Code WGP=Workgroup |
| 33 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 34 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 35 | TIME_RPTG_CD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Time Reporting Code Type
A=Amounts Only B=Both Hours and Amounts OK E=Either Hours or Amounts OK H=Hours Only U=Units Only |
| 36 | PAID_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Paid Flag |
| 37 | MIN_AMT | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Minimum Amount |
| 38 | MAX_AMT | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Maximum Amount |
| 39 | MIN_HRS | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Minimum Hours |
| 40 | MAX_HRS | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Maximum Hours |
| 41 | AMT_PER_INST | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Amount per instance |
| 42 | HRS_PER_INST | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Hours per instance |
| 43 | OVR_RATE_PER_HR | Signed Number(14,5) | DECIMAL(12,5) NOT NULL | Override Rate |
| 44 | DILUTE_LBDST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Used In Labor Dilution |
| 45 | HRS_REPRESENT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Hours Represent Indicator
A=Actual Hours C=Compensation Only Hours |
| 46 | COMP_TIME_IND | Character(1) | VARCHAR2(1) NOT NULL |
Compensatory Time Indicator
E=Compensatory Time Earned N=No Compensatory Time effect T=Compensatory Time Taken |
| 47 | ADD_GROSS | Character(1) | VARCHAR2(1) NOT NULL |
Add to Gross Pay
N=No Y=Yes |
| 48 | PERIOD_PRCS_DT | Date(10) | DATE | Period Process Date |
| 49 | TSK_DISTRIB_SEQ | Number(3,0) | SMALLINT NOT NULL | Task Distribution Sequence |
| 50 | REPORTED_AMT | Signed Number(12,5) | DECIMAL(10,5) NOT NULL | Reported Amount |
| 51 | REPORTED_HRS | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Reported Hours |
| 52 | REPORTED_UNITS | Signed Number(12,5) | DECIMAL(10,5) NOT NULL | Reported Units |
| 53 | LBR_DIST_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Labor Distribution Amount |
| 54 | EST_GROSS | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Estimated Gross |
| 55 | PC_QUALIFIED | Character(1) | VARCHAR2(1) NOT NULL | Projects Qualified |
| 56 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Projects Distribution Status
D=Distributed F=Finalized G=Generated H=Hold I=Ignore M=Modified N=None |
| 57 | TSKGRP_RULE_ID | Character(10) | VARCHAR2(10) NOT NULL | Taskgroup Alloc. Rule ID |
| 58 | TSEID | Character(7) | VARCHAR2(7) NOT NULL | Task Edit Set ID |
| 59 | TSEID_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Task Edit Set ID Flag |
| 60 | ADJ_TYPE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Adjustment Type
N=Normal R=Record-Only T=Task-Only X=No Adjustment |
| 61 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 62 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 63 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 64 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 65 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL | Product |
| 66 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project/Grant |
| 67 | TASK | Character(5) | VARCHAR2(5) NOT NULL | Task |
| 68 | CUSTOMER | Character(10) | VARCHAR2(10) NOT NULL | Customer |
| 69 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 70 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Resource Category |
| 71 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Resource Sub Category |
| 72 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Resource Type |
| 73 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 74 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 75 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 76 | QUANTITY_TMP | Signed Number(12,5) | DECIMAL(10,5) NOT NULL | Quantity |
| 77 | PROCESS_STATE_IND | Character(1) | VARCHAR2(1) NOT NULL |
Process State Indicator
A=Approved Time C=Created Time D=Range of Dates Update E=Edited Time L=Labor Distributed M=Lump Sum Update P=Pattern Update R=Rules Applied S=Scheduled Time T=Reported Time U=Rapid Time Update W=Crew Update |
| 78 | TRC_PROGRAM | Character(5) | VARCHAR2(5) NOT NULL | TRC Program ID |
| 79 | TRC | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 80 | GROUP_ID | Character(5) | VARCHAR2(5) NOT NULL | Group ID |
| 81 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 82 | DLYTASK_SEQNUM | Number(3,0) | SMALLINT NOT NULL | Daily Task Sequence Number |
| 83 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 84 | GROUP_BOOLEAN | Character(3) | VARCHAR2(3) NOT NULL |
Boolean for groups
AND=AND OR=OR |
| 85 | GROUP_LEFT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Left Parentheses for groups.
0= 1=( 2=(( 3=((( 4=(((( 5=((((( |
| 86 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 87 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 88 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 89 | GROUP_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL |
SQL operator for Groups
<=< <==<= <>=<> === >=> >==>= LIKE=LIKE |
| 90 | GROUP_VALUE | Character(30) | VARCHAR2(30) NOT NULL | Value for group selection criteria. |
| 91 | GROUP_RIGHT_PAREN | Character(1) | VARCHAR2(1) NOT NULL |
Right parentheses for group selection criteria.
0= 1=) 2=)) 3=))) 4=)))) 5=))))) |
| 92 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 93 | TIME_RPTG_CD | Character(5) | VARCHAR2(5) NOT NULL | Time Reporting code |
| 94 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 95 | COMP_TIME_PLAN | Character(10) | VARCHAR2(10) NOT NULL | Compensatory Time Off Plan |
| 96 | WORKGROUP | Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 97 | EFFDT | Date(10) | DATE | Effective Date |
| 98 | LD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Labor Distribution Used |
| 99 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL | The class used to determine row level security |
| 100 | INSTALLED_PAY_GBL | Character(1) | VARCHAR2(1) NOT NULL | Global Payroll Core |
| 101 | INSTALLED_PAY_NA | Character(1) | VARCHAR2(1) NOT NULL | Payroll for North America |
| 102 | SYSTEM_DATE | Date(10) | DATE | System Date |
| 103 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 104 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 105 | TASK_PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Task Profile ID |
| 106 | UPG_BOOLEAN1 | Character(1) | VARCHAR2(1) NOT NULL | UPG_BOOLEAN1 |
| 107 | UPG_BOOLEAN2 | Character(1) | VARCHAR2(1) NOT NULL | UPG_BOOLEAN2 |
| 108 | UPG_BRACKET1 | Character(1) | VARCHAR2(1) NOT NULL | UPG_BRACKET1 |
| 109 | UPG_BRACKET2 | Character(1) | VARCHAR2(1) NOT NULL | UPG_BRACKET2 |
| 110 | UPG_TL_LOAD_FLDSEC | Character(1) | VARCHAR2(1) NOT NULL | Load TL Field Security Table |
| 111 | COMMIT_ACCTG_FLG | Character(1) | VARCHAR2(1) NOT NULL | Commitment Accounting |
| 112 | PROJECT_COST_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Project Costing Flag |
| 113 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 114 | AE_STATE_RECNAME | Character(18) | VARCHAR2(18) NOT NULL | State Record |
| 115 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |
| 116 | DATETIME_STAMP | DateTime(26) | TIMESTAMP | DateTime Stamp |
| 117 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 118 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code SetID |
| 119 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 120 | COMP_LEAV_IND | Character(4) | VARCHAR2(4) NOT NULL |
Comp Leave Indiactor indicates whether a TRC has any effect on Leave and Compensatory time Off
CERN=Comp Time Earned CTKN=Comp Time Taken LTKN=Leave Taken NO=No Comp Time Effect RULE=Avoid Replacing by Rules |
| 121 | EFFDT_NEW | Date(10) | DATE | New Effective Date |
| 122 | MAX_NEG_HRS | Number(4,0) | SMALLINT NOT NULL | This Field is used to Define Maximum Positive Hours Allowed for a Compensatory Time Off Plan and for Leave Plan |
| 123 | SETID_RESOURCE | Character(5) | VARCHAR2(5) NOT NULL | Resource SetID |
| 124 | SETID_ACTIVITY | Character(5) | VARCHAR2(5) NOT NULL | Activity SetID |
| 125 | GRP_WHERE_CLS | Long Character(4096) | CLOB | Where Clause for Groups |
| 126 | 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 |
| 127 | PLAN_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 128 | SEQ_NBR1 | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 129 | SETID_SCHED | Character(5) | VARCHAR2(5) NOT NULL | SetID for Schedule ID |
| 130 | SCHEDULE_GRP | Character(10) | VARCHAR2(10) NOT NULL | Scheduling Organizational Group Code |
| 131 | BGN_DT_AFT | Date(10) | DATE | Begin Date |
| 132 | UPG_RELEASE_NUM | Number(5,0) | INTEGER NOT NULL | Release Number. Used in upgrade by UPG_RENAMED_PIN record. |
| 133 | DUR | Date(10) | DATE | Date Under Report associates time being reported, scheduled or paid, to a specific date. |
| 134 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 135 | SHIFT_ID | Character(10) | VARCHAR2(10) NOT NULL | Shift ID |
| 136 | PUNCH_TIME | Time(15) | TIMESTAMP | Punch Time |
| 137 | END_EFFDT | Date(10) | DATE | End Effdt |
| 138 | SCH_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Shift Type
E=Elapsed F=Flex P=Punch |
| 139 | SCHED_HRS | Signed Number(6,2) | DECIMAL(4,2) NOT NULL | Scheduled Work Hours |
| 140 | START_TIME | Time(15) | TIMESTAMP | Interview Start Time |
| 141 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |
| 142 | END_OFFSET | Signed Number(2,0) | DECIMAL(1) NOT NULL | Date Under Report Offset identifies the number of days following the start day of a shift to assign a specific punch to. If the punch lands on the same day as the start of the shift, the offset is zero. If it lands on the following day, then the offset is one and so on. |
| 143 | STRT_STOP_DIFF | Number(5,2) | DECIMAL(4,2) NOT NULL | Start Stop Time Duration |
| 144 | FLEX_START_TIME | Time(15) | TIMESTAMP | Flex Start Time identifies the earliest time that a Time Reporter working a Flex shift may consider to be the beginning of the shift. |
| 145 | FLEX_END_TIME | Time(15) | TIMESTAMP | Flex End Time identifies the latest time that a Time Reporter working a Flex shift may consider to be the end of the shift. |
| 146 | FLEX_WK_HRS | Number(3,0) | SMALLINT NOT NULL | Flex Weekly Hours identifies the number of hours expected to be worked and compensated for during one week on the flex shift. |
| 147 | SCH_CONFIG1 | Number(5,2) | DECIMAL(4,2) NOT NULL | Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition. |
| 148 | SCH_CONFIG2 | Number(5,2) | DECIMAL(4,2) NOT NULL | Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition. |
| 149 | SCH_CONFIG3 | Number(5,2) | DECIMAL(4,2) NOT NULL | Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition. |
| 150 | SCH_CONFIG4 | Number(5,2) | DECIMAL(4,2) NOT NULL | Schedule Configuration Total is used to capture user defined totals at teh shift and workday level. There are four totals available to the user. These totals are determined by the setting of the Schedule Configuration Indicators on the punch (shift segment) level as defined in the Shift Detail definition. |
| 151 | OFFDAY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Off Day Indicator
N=Work Shift Y=Off Shift |
| 152 | TIME_RPTG_TMPLT | Character(10) | VARCHAR2(10) NOT NULL | Time Reporting Template ID |