CHRIS Status History

DATA VIEW NAME

CHRIS_Status_History

OVERVIEW

CHRIS_Status_History displays classified transaction status history information. This table can be used to look up classified status history information such as status begin date, status end date, status duration, status description, etc.

LOAD FREQUENCY

Nightly (Monday through Friday)

DATA CUSTODIAN

Classified Human Resources Office
Contacts:
Catharine Derubeis

AUTHORIZATION

You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page

SPECIAL CONSIDERATIONS

There are no special considerations.

QUESTIONS

Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)

LAST UPDATED

02/2005 – New view created.
02/2006 — Added Status_Logonid C4j
11/2007 Updated data custodian c4j

DATA FORMAT

Primary Key Columns are identified with an asterisk(*)

Alphanumeric Data

VARCHAR2( N) (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’

Numeric Data

NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions.
X = total number of digits Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12

Date

DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.

Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)

Column Name	Format	Description
Status_History_Key	Number(15)	A unique identifier for an individual status history transaction in the CHRIS system.
HR_Transaction_Key	Number(15)	A unique identifier for an individual HR transaction in the CHRIS system.
Status_Descr	VarChar2(100)	Current status of transaction (i.e. Draft, Class Approved, Selected, Closed).
Status_Logonid	VarChar2(100)	Identifies the person responsible for each status transaction.
Status_Begin_Date	Date	Date transaction entered.
Status_End_Date	Date	This is a computed field. It equals the status begin date of the next (following) status record for a transaction. The last status end date should be the transaction end date.
Status_Duration	Number(4)	This is a computed field. It equals the number of days separating the status begin and end dates.
State_Transition_Descr	VarChar2(100)	Current status of transaction (i.e. Draft, Class Approved, Selected, Closed).
Extract_Date_Time	Date	The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS