Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_TIME_STATUS Table - Data Element Index . Tables and Data Elements . Career Tracker Home . Data Warehouse Home

CT_TIME_STATUS Table

(gradadm.ct_time_status)

Explanation
Time Status table from Career Tracker application. Referenced by Job Time Status in CT Job History table. eg) Part-time or Full-time

Common Uses
Decoding job_time_status column from the job history table.

Primary Key Indexed Data Elements Related Tables
STATUS_ID
 
      CT_JOB_HISTORY
 

Cautions
  • When writing queries outside of the BusinessObjects universe, status_id should be joined to the job_time_status column in the ct_job_history table.

CT_TIME_STATUS Table - Data Element Index . Tables and Data Elements . Career Tracker Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania