CHRS Knowledge Base

TAE Tables and Fields

Updated on

The purpose of this document is to assist campuses with creating or updating reports utilizing the TAE tables and fields. 

SETUP TABLES

Field Label Table
BUSINESS_UNIT Business Unit CSU_TF_ACAD_YR
CSU_ACAD_YEAR Academic Year CSU_TF_ACAD_YR
DESCR Description CSU_TF_ACAD_YR
DETAIL_BUTTON Display CSU_TF_ACAD_YR
END_DT End Date CSU_TF_ACAD_YR
START_DT Start Date CSU_TF_ACAD_YR
Action Reason
START_DT Start Date CSU_TF_ACAD_YR
Action Action CSU_TF_ACTN_RSN
ACTION_REASON Reason CSU_TF_ACTN_RSN
DETAIL_BUTTON Display CSU_TF_ACTN_RSN
EFFDT Effective Date CSU_TF_ACTN_RSN
EFF_STATUS Status CSU_TF_ACTN_RSN
TERM_WD_FLG Termed? CSU_TF_ACTN_RSN
Appointment Type
BUSINESS_UNIT Business Unit CSU_TF_APPT_TYP
CONTRACT_TYPE Appointment Type CSU_TF_APPT_TYP
CSU_APPT_DUR CSU AY Duration CSU_TF_APPT_TYP
CSU_TF_FUNC1 Set Appt End Dt CSU_TF_APPT_TYP
CSU_TF_FUNC2 Use Academic Year CSU_TF_APPT_TYP
CSU_TF_FUNC3 Require Entitlement CSU_TF_APPT_TYP
DESCR Description CSU_TF_APPT_TYP
DESCRSHORT Short Description CSU_TF_APPT_TYP
DETAIL_BUTTON Display CSU_TF_APPT_TYP
EFFDT Effective Date CSU_TF_APPT_TYP
EFF_STATUS Status CSU_TF_APPT_TYP
EMPL_CLASS Empl Class CSU_TF_APPT_TYP
EE and Job Groups
CSU_GROUP EE Group CSU_TF_EE_GROUP
CSU_TF_CALC_TYPE Calc Type CSU_TF_EE_GROUP
DESCR Description CSU_TF_EE_GROUP
EXEMPT_AMT_LBL EE Group 12 Combo? CSU_TF_EE_GROUP
EXEMPT_PARAMS_LBL AY CSU_TF_EE_GROUP
EXEMPT_VAR_LBL 12mo CSU_TF_EE_GROUP
JOBCODE Job Code CSU_TF_EE_GROUP
Pay Calendar    
BUSINESS_UNIT Business Unit CSU_TF_PAY_CAL
CALENDAR_YR Year CSU_TF_PAY_CAL
CSU_PAY_12 12 Month CSU_TF_PAY_CAL
SU_PAY_AY AY CSU_TF_PAY_CAL
CSU_PERIOD_12 Pay Period CSU_TF_PAY_CAL
CSU_PERIOD_AY Pay Period CSU_TF_PAY_CAL
DAY_OF_WK Calendar Day CSU_TF_PAY_CAL
DETAIL_BUTTON Display CSU_TF_PAY_CAL
EFFDT Calendar Day CSU_TF_PAY_CAL
Workflow Steps 
BUSINESS_UNIT Business Unit CSU_TF_STEPS
CSU_GROUP EE Group CSU_TF_STEPS
DEPTID Department CSU_TF_STEPS
DESCR Description/Label CSU_TF_STEPS
EFFDT EffDt CSU_TF_STEPS
FINAL_REF_IND Final Step? (Load to Job) CSU_TF_STEPS
JOBCODE Job Code CSU_TF_STEPS
LASTUPDDTTM Last Update Date/Time CSU_TF_STEPS
BY Last Updated By CSU_TF_STEPS
SEND_OK Send Appt Notification? CSU_TF_STEPS
ACCEPT_SCHED Send Email Approval? CSU_TF_STEPS
STEP Step#/Level CSU_TF_STEPS
Substitute Appointment
CSU_LAB_RT Lab Rate CSU_TF_SUBS_TBL
CSU_LEC_RT Lecture Rate CSU_TF_SUBS_TBL
CSU_NUM_WRK_DAYS Short Duration #Days CSU_TF_SUBS_TBL
DESCR Class Title CSU_TF_SUBS_TBL
GRADE Grade CSU_TF_SUBS_TBL
JOBCODE Job Code CSU_TF_SUBS_TBL
Summer Comp 
COUNT_1 Number of Students CSU_TF_SUMM_TBL
CSU_YEAR Summer Year CSU_TF_SUMM_TBL
PCT_EXEMPT % of Full Pay CSU_TF_SUMM_TBL
Term Table
BUSINESS_UNIT Business Unit CSU_TF_TERM_TBL
CSU_ACAD_YEAR Academic Year (AY) CSU_TF_TERM_TBL
CSU_GROUP EE Group CSU_TF_TERM_TBL
CSU_NUM_PAYCHECKS Number of Pay Months CSU_TF_TERM_TBL
CSU_NUM_WRK_DAYS Academic Days in Terms CSU_TF_TERM_TBL
CSU_SUMMER_SESSION Summer Session CSU_TF_TERM_TBL
CSU_TERM Term CSU_TF_TERM_TBL
CSU_TF_ACAD_YR1 Academic Year (1of3) CSU_TF_TERM_TBL
CSU_TF_ACAD_YR2 Academic Year (2of3) CSU_TF_TERM_TBL
CSU_UNITS #Units per AY CSU_TF_TERM_TBL
CSU_YEAR CSU Year CSU_TF_TERM_TBL
DESCR Description CSU_TF_TERM_TBL
DESCRSHORT Short Description CSU_TF_TERM_TBL
DETAIL_BUTTON Display CSU_TF_TERM_TBL
END_DATE End Date CSU_TF_TERM_TBL
SESSION_CODE Session Code CSU_TF_TERM_TBL
START_DATE Start Date CSU_TF_TERM_TBL
Process Defaults
BUSINESS_UNIT Business Unit CSU_TF_JC_DEF
COMP_FREQUENCY Comp Freq CSU_TF_JC_DEF
COMP_RATECD Comp Rt Code CSU_TF_JC_DEF
CSU_PAYROLL_STATUS PPT Status CSU_TF_JC_DEF
CSU_RET_CD Retirement Code CSU_TF_JC_DEF
CSU_SUMMER_JOBCODE Summer Job Code CSU_TF_JC_DEF
DETAIL_BUTTON Display CSU_TF_JC_DEF
EFFDT Effective Date CSU_TF_JC_DEF
EFF_STATUS Effective Status CSU_TF_JC_DEF
FICA_STATUS_EE FICA Status CSU_TF_JC_DEF
JOBCODE Job Code CSU_TF_JC_DEF
PAYGROUP Pay Group CSU_TF_JC_DEF
SPECIAL_CALCULATN Spec Calc lmm Pay CSU_TF_JC_DEF
Workflow Approvers
BUSINESS_UNIT  Business Unit CSU_TF_APPROVER
CSU_GROUP  EE Group CSU_TF_APPROVER
EMPLID Empl ID CSU_TF_APPROVER
EMPL_RCD  Empl Record CSU_TF_APPROVER
POSITION_NBR  Position Number CSU_TF_APPROVER
DEPTID Department CSU_TF_APPROVER
JOBCODE Job Code CSU_TF_APPROVER
CSU_AWE_STEP_1  Level 1 CSU_TF_APPROVER
CSU_AWE_STEP_10 Level 10 CSU_TF_APPROVER
CSU_AWE_STEP_2 Level 2 CSU_TF_APPROVER
CSU_AWE_STEP_3 Level 3 CSU_TF_APPROVER
CSU_AWE_STEP_4 Level 4 CSU_TF_APPROVER
CSU_AWE_STEP_5 Level 5 CSU_TF_APPROVER
CSU_AWE_STEP_6 Level 6 CSU_TF_APPROVER
CSU_AWE_STEP_7 Level 7 CSU_TF_APPROVER
CSU_AWE_STEP_8 Level 8 CSU_TF_APPROVER
CSU_AWE_STEP_9 Level 9 CSU_TF_APPROVER
HCI_AUTHORIZATION Authorization CSU_TF_APPROVER
LAST_SEG_IND  Last Segment Ind CSU_TF_APPROVER
AUTO_EE_TAX Automatic Employee Tax Data CSU_TF_APPROVER
Appointment Authority
BUSINESS_UNIT  Business Unit CSU_TF_AUTHORTY
CSU_GROUP EE Group CSU_TF_AUTHORTY
DEPTID Department CSU_TF_AUTHORTY
JOBCODE Job Code CSU_TF_AUTHORTY
EMPLID  Empl ID CSU_TF_AUTHORTY
EMPL_RCD  Empl Record CSU_TF_AUTHORTY
POSITION_NBR Position Number CSU_TF_AUTHORTY
LAST_SEG_IND  Last Segment Ind CSU_TF_AUTHORTY
AUTO_EE_TAX Automatic Employee Tax Data CSU_TF_AUTHORTY
 

Appointment / Approval Data

Field Label Table
EMPLID  Empl ID CSU_TF_TRAN_VW
EMPL_RCD Empl Record CSU_TF_TRAN_VW
EFFSEQ  Effective Sequence CSU_TF_TRAN_VW
EFFDT_USED  Date driving 'processed' code (Eff Dt) CSU_TF_TRAN_VW
CSU_CONTRACT_NBR  CSU Contract Number (Appt Number) CSU_TF_TRAN_VW
CSU_GROUP EE Group CSU_TF_TRAN_VW
SETID  SetID CSU_TF_TRAN_VW
BUSINESS_UNIT  Business Unit CSU_TF_TRAN_VW
EMPL_STATUS  Payroll Status (Status Popup) CSU_TF_TRAN_VW
CSU_ACKNOWLEDGE  Acknowledge CSU_TF_TRAN_VW
CSU_ACKNOWLEDGE_DT  CSU_EE_ACKNOW_DT CSU_TF_TRAN_VW
NOTIFIED_DT Date First Notified CSU_TF_TRAN_VW
CSU_ENTITLEMENT  Entitlement CSU_TF_TRAN_VW
CONTRACT_TYPE  Contract Type (Appt Type) CSU_TF_TRAN_VW
POSITION_NBR  Position Number CSU_TF_TRAN_VW
JOBCODE Job Code CSU_TF_TRAN_VW
GRADE  Salary Grade CSU_TF_TRAN_VW
CSU_TERM Term CSU_TF_TRAN_VW
ASOFDATE  As Of Date CSU_TF_TRAN_VW
DEPTID Department CSU_TF_TRAN_VW
SESSION_CODE  Session CSU_TF_TRAN_VW
COMPRATE Compensation Rate CSU_TF_TRAN_VW
HOURLY_RT  Hourly Rate CSU_TF_TRAN_VW
MONTHLY_RT  Monthly Rate CSU_TF_TRAN_VW
CSU_TERM_RATE Term Rate CSU_TF_TRAN_VW
CSU_LATE_START  Late Start (Adjust) CSU_TF_TRAN_VW
CSU_TOTAL_WTU  Total WTU CSU_TF_TRAN_VW
CSU_PAYROLL_STATUS  Payroll Status CSU_TF_TRAN_VW
TOTAL_AMT Total Budget Amount (Total Amount) CSU_TF_TRAN_VW
CSU_ITEM_215 Item 215 CSU_TF_TRAN_VW
COMMENTS_256  Comments CSU_TF_TRAN_VW
COMMENTS_NLD  Comments (Pushback, Delete) CSU_TF_TRAN_VW
CSU_PPT_COMMNT_FLG  CSU Default PPT Comment Flag CSU_TF_TRAN_VW
ACTION  Action CSU_TF_TRAN_VW
ACTION_REASON Reason Code CSU_TF_TRAN_VW
PAY_END_DT Pay Period End Date CSU_TF_TRAN_VW
CSU_MONTHS_OFF1  CSU Months Off #1 CSU_TF_TRAN_VW
CSU_MONTHS_OFF2  CSU Months Off #2 CSU_TF_TRAN_VW
FTE FTE CSU_TF_TRAN_VW
CONDITION Pre Post Condition CSU_TF_TRAN_VW
CSU_HOURS  Hours per Week CSU_TF_TRAN_VW
MIN_HRS  Minimum Hours CSU_TF_TRAN_VW
MAX_HRS Maximum Hours CSU_TF_TRAN_VW
CSU_STIPEND  CSU Indirect Stipend CSU_TF_TRAN_VW
COUNT1  Count (Student Count) CSU_TF_TRAN_VW
CSU_COURSE_NAME  Course Name CSU_TF_TRAN_VW
RATE Rate CSU_TF_TRAN_VW
REDUCED_RT  Reduced Rate CSU_TF_TRAN_VW
CSU_JAN_PAY  CSU_JAN_PAY CSU_TF_TRAN_VW
CSU_FEB_PAY  CSU_FEB_PAY CSU_TF_TRAN_VW
CSU_MAR_PAY CSU_MAR_PAY CSU_TF_TRAN_VW
CSU_APR_PAY  CSU_APR_PAY CSU_TF_TRAN_VW
CSU_MAY_PAY CSU_MAY_PAY CSU_TF_TRAN_VW
CSU_JUN_PAY CSU_JUN_PAY CSU_TF_TRAN_VW
CSU_JUL_PAY  CSU_JUL_PAY CSU_TF_TRAN_VW
CSU_AUG_PAY  CSU_AUG_PAY CSU_TF_TRAN_VW
CSU_SEP_PAY  CSU_SEP_PAY CSU_TF_TRAN_VW
CSU_OCT_PAY  CSU_OCT_PAY CSU_TF_TRAN_VW
CSU_NOV_PAY  CSU_NOV_PAY CSU_TF_TRAN_VW
CSU_DEC_PAY  CSU_DEC_PAY CSU_TF_TRAN_VW
COMP_RATE_TYPE Rate Code Type CSU_TF_TRAN_VW
PROJECT_ID  Project/Grant CSU_TF_TRAN_VW
CSU_LAB_LEC_CLS CSU_LAB_LEC_CLS CSU_TF_TRAN_VW
CSU_LAB_LEC_HRS CSU_LAB_LEC_HRS CSU_TF_TRAN_VW
CSU_LAB_LEC_RT CSU_LAB_LEC_RT CSU_TF_TRAN_VW
CSU_REH_ANNUITY CSU_REH_ANNUITY CSU_TF_TRAN_VW
CONTRACT_END_DT Contract End Date (Multi Term Dt) CSU_TF_TRAN_VW
CSU_DIFF_APPT  Different Appoint Nbr CSU_TF_TRAN_VW
CSU_READY_FLG  Ready? CSU_TF_TRAN_VW
TERM_END_DT  Term Ending Date (End Dt) CSU_TF_TRAN_VW
CSU_UNITS Units CSU_TF_TRAN_VW
CSU_NUM_PAYCHECKS  Number of Paychecks CSU_TF_TRAN_VW
CSU_EMPL_STAT CSU_EMPL_STAT (Other Action) CSU_TF_TRAN_VW
EXPECTED_RETURN_DT  Expected Return Date CSU_TF_TRAN_VW
CSU_APPT_DUR Duration of Appointment CSU_TF_TRAN_VW
SHIFT_FACTOR  Shift Differential Factor CSU_TF_TRAN_VW
CSU_RET_CD  Retirement Code CSU_TF_TRAN_VW
CSU_SSI_COUNTER SSI Counter CSU_TF_TRAN_VW
CSU_PROGRAM_NAME  Program Name CSU_TF_TRAN_VW
CSU_ASSIGN_TITLE  Assign Title CSU_TF_TRAN_VW
SAVE_AS_DRAFT Save As Draft CSU_TF_TRAN_VW
STEP  Step CSU_TF_TRAN_VW
EOAW_APPROVE Approve CSU_TF_TRAN_VW
EOAW_DENY Deny CSU_TF_TRAN_VW
EOAW_PUSHBACK  Pushback CSU_TF_TRAN_VW
EOAW_OPRID Operator ID CSU_TF_TRAN_VW
LOADED_TO_JOB  Loaded to Job CSU_TF_TRAN_VW
EOAWNEM_DATETIME DateTime Stamp CSU_TF_TRAN_VW
LASTUPDOPRID by CSU_TF_TRAN_VW
LASTUPDDTTM  Last Update Date/Time CSU_TF_TRAN_VW
LAST_UPDT_OPRID Last Updated User Name CSU_TF_TRAN_VW
LAST_UPDATE_DTM Last Modified CSU_TF_TRAN_VW
 

Concurrent and Additional Employment Section - Employee Self-Service

Field Label Table
EMPLID  Empl ID  CSU_TF_NOTIF
BUSINESS_UNIT Business Unit  CSU_TF_NOTIF
DEPTID  Department  CSU_TF_NOTIF
START_DATE  Start Date   CSU_TF_NOTIF
END_DATE End Date  CSU_TF_NOTIF
JOBTITLE  Job Title  CSU_TF_NOTIF
EMPLOYEE_IND Employee Indicator  CSU_TF_NOTIF
ALLOW_IND  Allow  CSU_TF_NOTIF
CSU_GROUP EE Group  CSU_TF_NOTIF
CSU_TOTAL_WTU Total WTU  CSU_TF_NOTIF
CSU_CONTRACT_NBR  CSU Contract Number  CSU_TF_NOTIF
COMMENTS Comment  CSU_TF_NOTIF
 

End of Article

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) TAE Frequently Asked Questions (FAQ)
Next Article (job aid) TAE Troubleshooting Guide

Temporary Academic Employment (TAE)

Data Entry/Approval (Job Aids: Step-by-Step Instructions) 17
TAE Reports (Job Aids: Step-by-Step Instructions) 10
TAE Configurations (Job Aids: Step-by-Step Instructions) 10
TAE Checklist 2
TAE Cheat Sheets/Troubleshooting 7
TAE Process Flows 1
Appointment Notification Examples 15
Standardization and Data Dictionary 2

Recently Updated Articles

More Recently Updated Articles