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 | Field Name 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 Seq Nbr |
| 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 | Reported Flag |
| 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
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 | Project Costing 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 | Project Costing Resource Category |
| 71 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Project Costing Resource Sub Category |
| 72 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Project Costing 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 | TL_GROUP_ID | Character(7) | VARCHAR2(7) NOT NULL | Time and Labor Groups |
| 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 Record |
| 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 | Signed Number(6,0) | DECIMAL(5) 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 Set ID |
| 118 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 119 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location Set ID |
| 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 Set ID |
| 124 | SETID_ACTIVITY | Character(5) | VARCHAR2(5) NOT NULL | Activity Set ID |
| 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 DN=Denied ES=Estimated IG=Ignore NA=Needs Approval NP=No Pay OE=Online Estimate PB=Pushed Back 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 | SEQ_NBR_EOEN | Number(15,0) | DECIMAL(15) NOT NULL | EOEN Sequence Nbr |
| 134 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |