- DATA VIEW NAME
- CL_PERSON
- OVERVIEW
- Basic employee information. There can be more than one record if the employee holds two (or more) independent jobs. There should be one record for each Person ID and Leave Department (Payroll Section and the UDDS part of a Payroll Entry Group). The amount of history will match what is on the IMS file LVACAPH which goes back to the Oct A 2006 Classified calc.
- LOAD FREQUENCY
- This data will be refreshed every two weeks, right after the classified leave calculation is run.
- DATA CUSTODIAN
- Office of Human Resources
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 the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 08/2010 – New view created.
11/2011 – Custodian change c4j. - DATA FORMATS
- 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 | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| *PERSON_KEY | INTEGER | Generated unique number based on Person_ID, Section Code, and Payroll Entry Group UDDS. This is a surrogate key for unique database identification. | ||||||||||||||||||||||||||||||||||||||
| PERSON_ID | VARCHAR2(8) | A unique number assigned to each person in the IADS HR system. | ||||||||||||||||||||||||||||||||||||||
| PERSON_NAME | VARCHAR2(30) | The name currently used by a person. The format will be last name, followed by a comma and a space, then first name or initial, middle initial or name, followed by a space plus Jr. or Sr. or III if appropriate. The only special character required is a comma to end the last name. | ||||||||||||||||||||||||||||||||||||||
| PAYROLL_SECTION_CODE | VARCHAR2(2) | Section containing PEG responsible for doing leave accounting. | ||||||||||||||||||||||||||||||||||||||
| PAYROLL_ENTRY_GROUP_UDDS | VARCHAR2(7) | UDDS of PEG responsible for doing leave accounting. | ||||||||||||||||||||||||||||||||||||||
| PEG_UNIT | VARCHAR2(1) | Unit of leave accounting UDDS. | ||||||||||||||||||||||||||||||||||||||
| PEG_DIVISION | VARCHAR2(2) | Division of leave accounting UDDS. | ||||||||||||||||||||||||||||||||||||||
| PEG_DEPARTMENT | VARCHAR2(4) | Department of leave accounting UDDS. | ||||||||||||||||||||||||||||||||||||||
| PAYROLL_ENTRY_GROUP_DESCR1 | VARCHAR2(21) | First alpha descriptive name of payroll entry group assigned by payroll office. | ||||||||||||||||||||||||||||||||||||||
| PAYROLL_ENTRY_GROUP_DESCR2 | VARCHAR2(21) | Second alpha descriptive name of payroll entry group assigned by payroll office. | ||||||||||||||||||||||||||||||||||||||
| SUPERVISOR_CODE | VARCHAR2(4) | Used for reporting leave information by groups. Defined by the user within the leave accounting UDDS. | ||||||||||||||||||||||||||||||||||||||
| SENIORITY_DATE | DATE | Employment start date or adjusted continuous service date. Used to compute length of service for classified employees. | ||||||||||||||||||||||||||||||||||||||
| SABBATICAL_ELIGIBILITY | VARCHAR2(1) | Eligibility indicator to show whether or not a person has ever been eligible to accumulate sabbatical leave using an accrued amount of sick leave. Valid values:
|
||||||||||||||||||||||||||||||||||||||
| BARGAINING_UNIT_CODE | VARCHAR2(2) | The bargaining unit associated with this employee or the non-lte classified positions held by the employee. Used by the leave accounting system. Entered directly via transaction ‘ADSV’ or updated when title code entered on classified splits with transactions ‘PMAS’ or ‘PMED’.
Valid values:
|
||||||||||||||||||||||||||||||||||||||
| BARGAINING_UNIT_DESCR | VARCHAR2(30) | Description of Bargaining Unit Code. | ||||||||||||||||||||||||||||||||||||||
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |