Docstoc

HRDataDictionaryforwebsite021309

Document Sample
HRDataDictionaryforwebsite021309 Powered By Docstoc
					                                                                07778499-2836-4a87-ab41-2bfa0087ad4a.xls - Reports


                Report                                                                                           Description

                                     Six adhoc reporting views are available for building your own employee queries and reports. ADHOC_PERS_V provides indicative data. ADHOC_EMPL_V
                                     provides employment data. ADHOC_APPT_V provides appointment data. ADHOC_ACCT_V provides account data. EMPLOYMENT_VW provides a
Ad Hoc Reporting                     combination of indicative, employment and appointment data. ADHOC_NYUIDS_MISSING_V lists employees who do not yet have an assigned NYUID.
                                     The Appointment Level report provides appointment level information for staff / administrators / faculty with expired or expiring appointments.

                                     The same level of information is available for both types of reports:
                                     NYU ID / Emplname / Job Title / Dept Name / Object Cd / Primary Stat / Grade / Appt Begin/End Dates / Emplstat / RegTemp / JobFmlyCd / Emp Ctgy Cd / As of
Appointment Level Report             Date / Appt Amt / Salary / Job No / Unit Name / Div Name.
                                     The Employee Headcount report lists all employees who have an active primary appointment within a given Unit, Division, or Department. The report covers all
                                     employees that are in the statuses Active, Leave with Pay, and Leave without Pay.

Employee Headcount by Unit, Division, Summary views provide counts based on Unit, Division, Department, and Object Code. Another view summarizes headcount based on employee categories --
Department                            Admin/Professional (100/110), Staff/Clerical (104/114, 106/116), Service (107/117), and Faculty (102/112).
                                     The purpose of this report is to give users the ability to view/assess the demographic makeup, with regards to gender and ethnicity, of all employees that fall
                                     under their purview.
                                     The primary data elements included in this report are Employee Name, Job Object Code, NYUID, Gender, Ethnicity/Race, Job Title, Appt Begin Date, Appt End
Employees by Object Code, Gender     Date, Job Class Code, Job Number, Employee Status, Reg/Temp Value, Job Family, Job Employee Category, Unit Name, Division Name, and Department
and Ethnicity                        Name.
New Hires and Transfers              This report is used by the Schools/Unit to identify (1) employees new to NYU and (2) employees who transfer into a new department.
                                     The PASS actions report displays the PASS and xPASS actions history for all employees selected within a Unit, Division, Department or for individual employees.
                                     Use this report to (1) show the Job history for employees (data is limited to the time period during which the PASS and xPASS applications have been available),
PASS Actions by Unit / Division /    (2) track the progress of submitted actions, (3) analyze transaction volume over time, or (4) track the time to completion for selected actions from submission to
Department                           posting.

                                     The first subreport, the All Paycheck History report provides high level
                                     paycheck info for a specific employee for all paychecks. This
                                     enables a user to see if someone got paid, how they got paid, and their
                                     gross pay.

                                     The second subreport, the Paycheck Earnings Detail report, provides
                                     info related to earnings types and amounts for a specific employee
                                     for a specific paycheck. This enables a user to see the types of earnings an employee earned
Paycheck History/Details             including vacation, sick, overtime, and more.
                                     The Probationary Period Review report is used by the Schools/Unit to find out the probationary end date of employees. All new employees undergo a
                                     probationary period that begins on the first day of employment. The probationary period is the initial period of employment, a kind of trial period, during which the
                                     supervisor carefully considers whether the employee is able to meet the standards and expectations of the job and if the employee should be retained by NYU as
Probationary Period Review           a regular employee.
                                     The Separations report lists all employees who are leaving a given appointment within NYU. The report can be used by HROs or their staff to identify employees
                                     leaving their School or Unit and to ensure that offboarding steps are completed.

                                     The employees covered within this report include (1) employees who have resigned or have been terminated and are leaving the University, (2) employees who
Separations Report                   are transferring out of a department, and (3) employees with expired appointments.
                                     This report is used to view accrued, earned, and taken hourly balances and pay for sick and vacation days. It includes all eligible employees with primary
Vacation and Sick Balances           appointments in a Unit with job object codes: 104, 114, 106, 116, 107, and 117.
                                     The report identifies all employees that have a temporary work authorization within HRIS. This report allows the Talent Management Office, Office of Academic
                                     Appointment or HROs and HR staff to list all employees within their School, Unit, Division, or Department along with their visa type and expiration date as of a
                                     specified date. It identifies the number of days to expiration, highlights those that are expiring within 120, 90, 60, 30 days, as well as those that are already
Visa Expiration and I-9 Status       expired.
                                                            07778499-2836-4a87-ab41-2bfa0087ad4a.xls - Views


         View                                                             Description                                                                   Use this to report on
ADHOC_ACCT_V             The Account view provides account lines for employee appointments. Use this view to create your own adhoc Account details for employee appointments.
                         reports. This view can be joined with the other adhoc reporting views to query for more employee data.

ADHOC_APPT_V             The Appointment view provides appointment details for employees. Use this view to create your own adhoc       Appointment details for employees.
                         reports. This view can be joined with the other adhoc reporting views to query for more employee data.

ADHOC_EMPL_V             The Employment view provides employment details for employees. Use this view to create your own adhoc         Employment details for employees.
                         reports. This view can be joined with the other adhoc reporting views to query for more employee data.

ADHOC_EMPLOYMENT_V       The Employment view provides indicative, employment and appointment data for all employees.                   Employee and job details for any appointments in HRIS.
ADHOC_NYUIDS_MISSING_V   The Missing NYUIDs view lists employees who do not yet have an assigned NYUID.                                Employees without an assigned NYUID. Use emplid to join to
                                                                                                                                       this table.
ADHOC_PERS_V             The Personal view provides personal and biographical details for employees. Use this view to create your      Personal details for employees.
                         own adhoc reports. This view can be joined with the other adhoc reporting views to query for more employee
                         data.
EMPLOYMENT_VW            The Employment view provides indicative, employment and appointment data for all employees.                   Employee and job details for any appointments in HRIS.
HEADCOUNTS_V             HEADCOUNTS_V is a view containing all relevant employee demographic and appointment information               Employee headcount.
                         needed to report on all active employees and calculate the official University headcount based on the primary
                         job.
PASS_ACTIONS_V           The PASS Actions view is a secured view of PASS request data.                                                 PASS transaction data.
PASS_HIRES_TRFS_V        The PASS Hires & Transfers view provides detailed information on all PASS transactions processed within a     PASS Hires and Transfers data.
                         specified date range.
PAY_HIST_BAS_V           The Payroll History view provides paycheck data for employees. There is one row per employee per              Paycheck data for employees.
                         paycheck in this table. Eighteen months of history is stored on a rollling basis.
PAY_HIST_ERN_V           The Payroll Earnings Detail view provides earnings data for employees. There is one row per type of earning   Payroll earnings detail data for employees.
                         per employee per paycheck (there may be multiple rows per paycheck per employee) in this table. Eighteen
                         months of history is stored on a rollling basis.
SEPARATIONS_V            The Separations view provides summary information on employees who have separated from the University Employees who have officially separated from the University.
                         within a specified date range.
VAC_SICK_BAL_V           The Vacation and Sick Balances view provides payroll gross and balances for vacation and sick time. Payroll Gross/total earnings, hours and balances related to vacation
                         gross to net data for FYTD and YTD come from the ISI_EDB_GRS_T payroll gross table. Balances of various and sick time.
                         accumulations based on hours, including vacation and sick accrued, earned, taken and balances come from
                         the ISI_EDB_HRS_T hours balances table.
XPASS_HIRES_TRFS_V       The XPASS Hires & Transfers view provides detailed information on all XPASS transactions processed within XPASS Hires and Transfers data.
                         a specified date range.
                                                                                                                                                                                            07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View               Field                                               Description                                                   Data Type   Length Example                                          Source Table        Source Field                  Additional Info 1                             Additional Info 2                               Additional Info 3                                            Additional Info 4
ADHOC_ACCT_V     Emplkey             System generated employee key used to join adhoc views for query purposes                                VARCHAR2         35
ADHOC_ACCT_V     Orgid               Active employees are stored in the Active Org which is OrgID=blank; Retirees are in the RET org          VARCHAR2         13 <blank> or <RET>
                                     with OrgID=RET.
ADHOC_ACCT_V     Nyuid               University ID - System generated employee identification number used to uniquely identify                VARCHAR2         11 N12345678
                                     employees and is not the same as the employee social security number.
ADHOC_ACCT_V     Jobno               JobNo is the physical number of the job in the database; Prty_Cd is the priority of the job. JobNo       DATE                  1                                            ISI_EDB_JOB,     JOBNO
                                     gets reset nightly to the Prty_Cd. Use Prty_Cd instead of JobNo. An employee can have up to 7                                                                               ISI_EDB_ACC,
                                     jobs. Job #7 is for Payroll use only.                                                                                                                                       NYU_EDB_JOB,
                                                                                                                                                                                                                 NYU_EDB_ACT
ADHOC_ACCT_V     Jobdept             Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be             VARCHAR2          8 43020                                          ISI_EDB_JOB      JOBDEPT
                                     from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                     Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
ADHOC_ACCT_V     Object Cd           Identifies the general type of work performed and the full-time/part-time status for the PRIMARY         INTEGER               100 - Admin/professional (FT)                NYU_EDB_EMP_T OBJECT_CD                                                                                                             JOB_OBJECT_CD (OBJECT_CD on                       100 - Admin/professional (FT)
                                     (job #1) assignment of the employee.                                                                                           102 - Faculty (FT)                                                                110 - Admin/professional (PT)                                                                  NYU_EDB_JOB_T) is the object code of the          101 - Teaching or graduate assistant (FT)
                                                                                                                                                                                                                                                      111 - Grader, tutor, lab assistant (PT)        118 - Student (workstudy)                       particular job. Use the Object Code from the      102 - Faculty (FT)
                                                                                                                                                                                                                                                      112 - Faculty (PT)                             119 - Student (non-workstudy)                   Emp_T table if you are looking at primary         103 - Professional researcher (FT)
                                                                                                                                                                                                                                                      113 - Professional researcher (PT)             130 - Research assistant (FT)                   jobs, use the object code from the Job_T          104 - Laboratory/technical staff (FT)
                                                                                                                                                                                                                                                      114 - Laboratory/technical staff (PT)          131 - Research assistant (FT)                   table if you are looking at the object codes of   106 - Office/clerical staff (FT)
                                                                                                                                                                                                                                                      115 - Casual employee (PT)                     542 - Post-doctoral fellow (FT)                 all jobs.                                         107 - Service staff (FT)
                                                                                                                                                                                                                                                      116 - Office/clerical staff (PT)
                                                                                                                                                                                                                                                      117 - Service staff (PT)

ADHOC_ACCT_V     Acctid              The number of the account line record. Each account line associated with a job has its own               INTEGER               1
                                     incremental unique number.
ADHOC_ACCT_V     Acctno              The account number (chartfield combination) associated with the account line record.                     CHAR             25 511001020870
ADHOC_ACCT_V     Acctamt             The amount of gross pay charged to this account for each pay period.                                     NUMBER           11 2,500.00                                       ISI_EDB_ACC      ACCTAMT                                                                                                                                                              9-digit numeric.
                                     For salaries or lump sum payments (such as bonuses or stipends), this field contains the gross                                                                                                                                                                                                                                                                    Format: 9999999.999, or blank.
                                     pay charged to the account for each pay period.
                                     This field is blank for hourly wages.
ADHOC_ACCT_V     Earntype            Identifies the type of payments or deductions or reductions associated with this account line.           CHAR              3 R12                                            ISI_EDB_ACC      EARNTYPE
                                     Required.
                                     3-character alphanumeric.
                                     Valid codes are listed on the Earnings Table.
                                     Examples: OTS - Overtime pay
                                     REG - Regular pay
                                     RSK - Sick leave
                                     RVC - Vacation


ADHOC_ACCT_V     Acctstrt            The earliest date that charges may be applied against this account.                                      DATE                  09/01/05 12:00 AM                            ISI_EDB_ACC      ACCTSTRT                                                                                                                                                             Valid formats:
                                     Generally the last three positions of the ACCOUNT chartfield identify the OBJ CD for the job                                                                                                                                                                                                                                                                      MMDDYYYY
                                     assignment.                                                                                                                                                                                                                                                                                                                                                       MM/DD/YYYY
                                                                                                                                                                                                                                                                                                                                                                                                       MM-DD-YYYY
                                                                                                                                                                                                                                                                                                                                                                                                       MM DD YYYY
                                                                                                                                                                                                                                                                                                                                                                                                       MM.DD.YYYY
ADHOC_ACCT_V     Acctstop            The last date charges are to be applied to this account.                                                 DATE                  12/31/99 12:00 AM                            ISI_EDB_ACC      ACCTSTOP
                                     Required.
                                     10-character alphanumeric (maximum)
                                     Valid formats:
                                     MMDDYYYY
                                     MM/DD/YYYY
                                     MM-DD-YYYY
                                     MM DD YYYY
                                     MM.DD.YYYY

ADHOC_ACCT_V     Acctpct             Identifies the percent of full-time wages charged to this account. This field is used to calculate the   NUMBER            5 100                                            ISI_EDB_ACC      ACCTPCT                                                                                                                                                              6-digit numeric.
                                     number of hours on time reports.                                                                                                                                                                                                                                                                                                                                  Format: 9999.99
                                     Required for hourly paid employees; used for salaried employees when funding is distributed
                                     among several accounts.
ADHOC_ACCT_V     Acct Dol Amt        Account dollar amount.                                                                                   NUMBER            9 30,000.00
ADHOC_APPT_V     Emplkey             System generated employee key used to join adhoc views for query purposes                                VARCHAR2         35
ADHOC_APPT_V     Orgid               Active employees are stored in the Active Org which is OrgID=blank; Retirees are in the RET org          VARCHAR2         13 <blank> or <RET>
                                     with OrgID=RET.
ADHOC_APPT_V     Nyuid               University ID - System generated employee identification number used to uniquely identify                VARCHAR2         11 N12345678
                                     employees and is not the same as the employee social security number.
ADHOC_APPT_V     Emplname            Name of employee.                                                                                        VARCHAR2         30                                                ISI_EDB_BAS      EMPLNAME
                                     Valid format: Last name, comma, first name, space, middle initial
ADHOC_APPT_V     Jobno               JobNo is the physical number of the job in the database; Prty_Cd is the priority of the job. JobNo       DATE                  1                                            ISI_EDB_JOB,     JOBNO
                                     gets reset nightly to the Prty_Cd. Use Prty_Cd instead of JobNo. An employee can have up to 7                                                                               ISI_EDB_ACC,
                                     jobs. Job #7 is for Payroll use only.                                                                                                                                       NYU_EDB_JOB,
                                                                                                                                                                                                                 NYU_EDB_ACT
ADHOC_APPT_V     Prty Cd             Priority code of 1 should be assigned to the primary job assignment. An employee can have up to INTEGER                        1                                            NYU_EDB_JOB      PRTY_CD
                                     7 jobs and must have one appointment with priority 1. No two appointments may have the same
                                     priority. Job priority 7 is for Payroll use only.
ADHOC_APPT_V     Job Object Cd       JOB_OBJECT_CD, which is listed as field OBJECT_CD on the NYU_EDB_JOB_T table is the                      INTEGER               100 - Admin/professional (FT)                NYU_EDB_JOB_T    OBJECT_CD           OBJECT_CD, which is listed as field            Use the Object Code from the Emp_T table if
                                     object code of the particular job- each job has one.                                                                           102 - Faculty (FT)                                                                OBJECT_CD on the NYU_EDB_EMP_T table,          you are only looking at primary jobs, use the
                                                                                                                                                                                                                                                      is the object code of the primary job and is   object code from the Job_T table if you are
                                                                                                                                                                                                                                                      defaulted from the Object Code of Job #1.      looking at the object codes of all jobs.

ADHOC_APPT_V     Job Rate Cd         The rate code associated with this job assignment identifying if this is a salaried or hourly job.       CHAR              1

ADHOC_APPT_V     Jobdept             Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be             VARCHAR2          8 43020                                          ISI_EDB_JOB      JOBDEPT
                                     from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                     Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
ADHOC_APPT_V     Jobclass            The job classification code assigned to this job assignment.                                             VARCHAR2          6 220163                                         ISI_EDB_JOB      JOBCLASS
                                     Can be decoded using HR.ISI_CDB_JOB_T table.
                                     6-character alphanumeric.
                                     Use the table look-up feature to find current values and translations.
ADHOC_APPT_V     Job Ttl 1           The job assignment title for this job assignment.                                                        CHAR             30 DEVELOPMENT COMMUNICATIONS MAN                 NYU_EDB_JOB      JOB_TTL_1
                                     60-character alphanumeric (stored as two 30-position fields).



                                                                                                                                                                                                                                                                                                                                                                                                                                          Page 3 of 28
                                                                                                                                                                                              07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View               Field                                                 Description                                                 Data Type   Length Example                                            Source Table        Source Field                   Additional Info 1                               Additional Info 2                               Additional Info 3                                            Additional Info 4
ADHOC_APPT_V     Job Ttl 2           The job assignment title for this job assignment.                                                        CHAR             30 AGER                                             NYU_EDB_JOB      JOB_TTL_2
                                     60-character alphanumeric (stored as two 30-position fields).
ADHOC_APPT_V     Job Fmly Cd         This code identifies the general functional responsibility of this job assignment.                       CHAR              1 A - Administrative services                      NYU_EDB_JOB      JOB_FMLY_CD         1 - Finance                                       A - Administrative services                    G - General administrative support                 Q - Admissions, registration, and financial aid
                                                                                                                                                                                                                                                        2 - Communications                                B - Sergeant guards (for object code 107,      K - Communications                                 S - Survivors of retirees
                                                                                                                                                                                                                                                        3 - Institutional facilities                      117)                                           L - Library, technical, and data processing (for   T - Animal, dental/medical, media lab technicians
                                                                                                                                                                                                                                                        4 - Administrative services                       C - Elevator starters (for object code 107,    object code 100, 110)                              X - Academic administrators not in plan
                                                                                                                                                                                                                                                        5 - Student affairs                               117)                                           L - Comp, equip fab, general technical             Z - Student affairs
                                                                                                                                                                                                                                                        6 - Admissions, registration, and financial aid   D - Academic support (for object code 100,     support (for object code 104, 114)
                                                                                                                                                                                                                                                        7 - Library, technical, and data processing       110)                                           N - Institutional facilities
                                                                                                                                                                                                                                                        8 - Academic support                              D - Cdl, dental equipment repair technicians
                                                                                                                                                                                                                                                                                                          (for object code 104, 114)
                                                                                                                                                                                                                                                                                                          F - Finance

ADHOC_APPT_V     Emp Ctgy Cd         The employee category associated with this job assignment which identifies a grouping of similar         VARCHAR2          1 F - Faculty                                      NYU_EDB_JOB      EMP_CTGY_CD         A - Administrative and Professional               N - Student
                                     jobs for reporting purposes.                                                                                                                                                                                       D - Post-Doctoral Fellows                         R - Professional Researcher
                                                                                                                                                                                                                                                        F - Faculty                                       S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                                        G - Unpaid appointments                           T - Casual employees
                                                                                                                                                                                                                                                        K - Graduate, Research, and Teaching              X - University Officers
                                                                                                                                                                                                                                                        Assistants                                        Z - Retired employees
                                                                                                                                                                                                                                                        M - Management, Directors and Academic
                                                                                                                                                                                                                                                        Administrators
ADHOC_APPT_V     Job Acct Tot Amt                                                                                                             NUMBER          9,3 2,500.00
ADHOC_APPT_V     Job Bse Sal Amt                                                                                                              NUMBER          9,2 0
ADHOC_APPT_V     Aptbegdt            The date this job assignment or appointment is effective.                                                DATE                09/01/05 12:00 AM                                ISI_EDB_JOB      APTBEGDT                                                              To set the limit to get active appointments                                                       Valid formats:
                                     The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                                  only                                                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                                            - Use APTBEGDT < sysdate and                                                                    MM DD YYYY
                                                                                                                                                                                                                                                                                                          APTENDDT > sysdate                                                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                                          To identify cancelled appointments:                                                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                                            - APTBEGDT = APTENDDT and                                                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                                          APPT_AMT = 1
ADHOC_APPT_V     Aptenddt            The date this job assignment or appointment ends.                                                        DATE                  12/31/99 12:00 AM                              ISI_EDB_JOB      APTENDDT                                                              To set the limit to get active appointments                                                       Valid formats:
                                     The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                                  only                                                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                                            - Use APTBEGDT < sysdate and                                                                    MM DD YYYY
                                                                                                                                                                                                                                                                                                          APTENDDT > sysdate                                                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                                          To identify cancelled appointments:                                                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                                            - APTBEGDT = APTENDDT and                                                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                                          APPT_AMT = 1
ADHOC_APPT_V     Appt Amt            This field is calculated based on PAY TERM, PAY RATE, and PAY CYCLE. Appt Amount is stored NUMBER                        9,3 30,000.00                                        NYU_EDB_JOB      APPT_AMT            This field is calculated based on PAY TERM,       OC 100,110 -> B1 pay cycle -> any pay term -   When ApptAmt=$1.00, employee will not be           OC 102,112,103,113 -> 22,92 pay term -> appt amt = PAY RATE x
                                     as annual base, monthly pay, weekly pay, gross pay during period of appointment, etc based on                                                                                                                      PAY RATE, and PAY CYCLE.                          > appt amt = PAY RATE x 26                     paid. Either: 1) person has an affiliated appt     12
                                     different object codes.                                                                                                                                                                                            OC 104,114,106 -> any pay cycle -> any pay        OC 115,118,119 -> any pay cycle -> any pay     but does not get paid by NYU, 2) Person on         OC 102,112,103,113 -> 96 pay term -> appt amt = PAY RATE x 6
                                                                                                                                                                                                                                                        term -> appt amt = PAY RATE x work hours          term -> appt amt = PAY RATE                    an unpaid leave of absence, 3) appt is             OC 102,112,103,113 -> 97 pay term -> appt amt = PAY RATE x 7
                                                                                                                                                                                                                                                        OC 116,107,117, 100, 110 -> M1 paycycle ->        OC 102,112,103,113 -> any pay cycle -> 01-     cancelled (ApptAmt=$1.00 AND the Appt              OC 102,112,103,113 -> 98 pay term -> appt amt = PAY RATE x 9
                                                                                                                                                                                                                                                        any pay term -> appt amt = PAY RATE x 12          11 pay term -> appt amt = PAY RATE x PAY       Begin Date=Appt End Date)
                                                                                                                                                                                                                                                                                                          TERM


ADHOC_APPT_V     Crse Ttl            Identifies the course section number taught by the instructor for this job (not required).               CHAR
ADHOC_APPT_V     Cntct Hrs           Identifies the contact hours associated with the course taught by the instructor for this jo (not        NUMBER          6,2 0
                                     required).
ADHOC_APPT_V     Cntct Typ Cd        A code available for school use to further identify the affiliation with a course (not required) of an   CHAR              1
                                     instructor.
ADHOC_APPT_V     Job Stamp           A unique timestamp per job in the database.                                                              VARCHAR2         26 2005-09-01-20.06.27
ADHOC_APPT_V     Payrate             Identifies the job rate of pay per pay cycle of the employee.                                            NUMBER           11 2,500.00
ADHOC_APPT_V     Paystat                                                                                                                      VARCHAR2          1
ADHOC_APPT_V     Payterm             Identifies the length of the job assignment and the period of payment.                                   VARCHAR2            02 - 10-month assignment paid over 12 months     ISI_EDB_JOB      PAYTERM             00 - 10-month assignment paid over 10 months      90 - 9-month assignment paid over 10                                                              97 - 4 1/2 month assignment paid over 7 months (spring)
                                                                                                                                                                                                                                                        01-09 - specific number of payments for temp.     months                                                                                            98 - 9-month assignment paid over 8 months
                                                                                                                                                                                                                                                        appt.                                             92 - 9-month assignment paid over 12
                                                                                                                                                                                                                                                        02 - 10-month assignment paid over 12 months      months
                                                                                                                                                                                                                                                        12 - 11-month assignment paid over 12 months      94 - 4 1/2 month assignment paid over 4
                                                                                                                                                                                                                                                        22 - 12-month assignment paid over 12 months      months (fall, spring)
                                                                                                                                                                                                                                                                                                          96 - 4 1/2 month assignment paid over 6
                                                                                                                                                                                                                                                                                                          months (fall)



ADHOC_APPT_V     Pctfull                                                                                                                      NUMBER          5,2 100
ADHOC_APPT_V     Ratecode            Indicates if PAY RATE is hourly or payment for the pay period.                                           VARCHAR2          1 P - Salary for pay period                        ISI_EDB_JOB      RATECODE
                                     1-character alphanumeric.
                                     Valid codes:
                                     H - Hourly rate
                                     P - Salary for pay period
ADHOC_APPT_V     Req To Rcrt         Request to Recruit number.                                                                               CHAR              6
ADHOC_APPT_V     Job Eval No         Job evaluation code.                                                                                     CHAR              9
ADHOC_APPT_V     Job Descr Txt       Job description code.                                                                                    CHAR             14
ADHOC_EMPL_V     Emplkey             System generated employee key used to join adhoc views for query purposes                                VARCHAR2         35
ADHOC_EMPL_V     Orgid               Active employees are stored in the Active Org which is OrgID=blank; Retirees are in the RET org          VARCHAR2         13 <blank> or <RET>
                                     with OrgID=RET.
ADHOC_EMPL_V     Nyuid               University ID - System generated employee identification number used to uniquely identify                VARCHAR2         11 N12345678
                                     employees and is not the same as the employee social security number.
ADHOC_EMPL_V     Emplname            Name of employee.                                                                                        VARCHAR2         30                                                  ISI_EDB_BAS      EMPLNAME
                                     Valid format: Last name, comma, first name, space, middle initial
ADHOC_EMPL_V     Orighrdt            This field preserves the original hire date of the employee in case of a break in employment and         DATE                  09/01/05 12:00 AM                              ISI_EDB_BAS      ORIGHRDT
                                     later reemployment. (Also called floor date.)
ADHOC_EMPL_V     Emplmtdt            Employment date. Generally this date is updated when an employee moves into/out of a benefits-           DATE                  09/01/05 12:00 AM
                                     eligible assignment.
ADHOC_EMPL_V     Emplstat            Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either             VARCHAR2          1 A
                                     = A,L, P or EMPLSTAT <> T for query/reporting limits.
ADHOC_EMPL_V     Statusdt            The effective date of the Employment Status (see Emplstat) of an employee.                               DATE                  09/01/05 12:00 AM




                                                                                                                                                                                                                                                                                                                                                                                                                                                Page 4 of 28
                                                                                                                                                                                            07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                 Field                                               Description                                                 Data Type   Length Example                                          Source Table     Source Field                      Additional Info 1                                 Additional Info 2                                         Additional Info 3                                              Additional Info 4
ADHOC_EMPL_V     Object Cd             Identifies the general type of work performed and the full-time/part-time status for the PRIMARY      INTEGER              100 - Admin/professional (FT)                  NYU_EDB_EMP_T OBJECT_CD                                                                                                                          JOB_OBJECT_CD (OBJECT_CD on                       100 - Admin/professional (FT)
                                       (job #1) assignment of the employee.                                                                                       102 - Faculty (FT)                                                                  110 - Admin/professional (PT)                                                                               NYU_EDB_JOB_T) is the object code of the          101 - Teaching or graduate assistant (FT)
                                                                                                                                                                                                                                                      111 - Grader, tutor, lab assistant (PT)            118 - Student (workstudy)                                particular job. Use the Object Code from the      102 - Faculty (FT)
                                                                                                                                                                                                                                                      112 - Faculty (PT)                                 119 - Student (non-workstudy)                            Emp_T table if you are looking at primary         103 - Professional researcher (FT)
                                                                                                                                                                                                                                                      113 - Professional researcher (PT)                 130 - Research assistant (FT)                            jobs, use the object code from the Job_T          104 - Laboratory/technical staff (FT)
                                                                                                                                                                                                                                                      114 - Laboratory/technical staff (PT)              131 - Research assistant (FT)                            table if you are looking at the object codes of   106 - Office/clerical staff (FT)
                                                                                                                                                                                                                                                      115 - Casual employee (PT)                         542 - Post-doctoral fellow (FT)                          all jobs.                                         107 - Service staff (FT)
                                                                                                                                                                                                                                                      116 - Office/clerical staff (PT)
                                                                                                                                                                                                                                                      117 - Service staff (PT)

ADHOC_EMPL_V     Homedept              Primary (home) department of an employee (department of the primary appointment). Jobdept is VARCHAR2                     8 56210                                         ISI_EDB_BAS    HOMEDEPT
                                       the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                       Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

ADHOC_EMPL_V     Emp Ctgy Cd           The employee category associated with this job assignment which identifies a grouping of similar      VARCHAR2            1 F - Faculty                                   NYU_EDB_JOB    EMP_CTGY_CD           A - Administrative and Professional                N - Student
                                       jobs for reporting purposes.                                                                                                                                                                                   D - Post-Doctoral Fellows                          R - Professional Researcher
                                                                                                                                                                                                                                                      F - Faculty                                        S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                                      G - Unpaid appointments                            T - Casual employees
                                                                                                                                                                                                                                                      K - Graduate, Research, and Teaching               X - University Officers
                                                                                                                                                                                                                                                      Assistants                                         Z - Retired employees
                                                                                                                                                                                                                                                      M - Management, Directors and Academic
                                                                                                                                                                                                                                                      Administrators
ADHOC_EMPL_V     Fctly Bse Sal Amt     The annualized salary of the primary appointment. Although this is labeled Faculty base, this field   NUMBER            9,2 30,000                                                                             OC 104,114,106 -> any pay cycle/term -> base       OC 103 -> any pay cycle/term -> base salary              Does not include administrative stipend or        OC 102 -> any pay cycle -> 96 pay term -> base salary = PAY RATE
                                       is populated not only for code 102s, but 103s, 113s, 100s and 110s.                                                                                                                                            salary = PAY RATE x work hours x 52                = PAY RATE x 12                                          additional compensation for miscellaneous         x 12
                                                                                                                                                                                                                                                      OC 116,107,117, 100,110 -> M1 pay cycle ->         OC 112,113,118 -> any pay cycle/term -> no               short-term assignments.                           OC 102 -> any pay cycle -> 97 pay term -> base salary =PAY RATE
                                                                                                                                                                                                                                                      any pay term -> base salary = PAY RATE x 12        BASE SALARY                                                                                                x 14
                                                                                                                                                                                                                                                      OC 100,110 -> B1 pay cycle -> any pay term ->      OC 119, 102 -> any pay cycle -> 92 pay term          -
                                                                                                                                                                                                                                                      base salary = PAY RATE x 26                        > base salary = PAY RATE x 12



ADHOC_EMPL_V     Partfull              Indicates whether the employee is full time or part time.                                             VARCHAR2            1 F
                                       Valid codes:
                                       F - Full
                                       P - Part
ADHOC_EMPL_V     Regtemp               Indicates whether the primary job assignment of the employee is regular or temporary.                 VARCHAR2            1 R - Regular                                   ISI_EDB_BAS    REGTEMP
                                       Valid codes:
                                       R - Regular
                                       T - Temporary
ADHOC_EMPL_V     Wrk Hrs               The standard work hours for the employee in a normal work week. This number is used to                NUMBER            4,2 35                                            NYU_EDB_EMP    WRK_HRS
                                       determine the correct accrual rate for vacation and sick leave.
                                       4-digit numeric.
                                       Formatted 99.99.
                                       Valid values: 00.00 - 40.00.
ADHOC_EMPL_V     Loa Bgn Dt            The date the leave of absence of the employee begins.                                                 DATE                  01/01/01 12:00 AM                             NYU_EDB_EMP    LOA_BGN_DT
                                       10-character alphanumeric (maximum).
                                       Valid formats are:
                                       MMDDYYYY
                                       MM DD YYYY
                                       MM/DD/YYYY
                                       MM-DD-YYYY
                                       MM.DD.YYYY
ADHOC_EMPL_V     Loa Pay Pct           The percent of base pay the employee receives while on leave.                                         DATE                  0                                             NYU_EDB_EMP    LOA_PAY_PCT
                                       3-digit numeric.
                                       Formatted 999.
                                       Valid codes:
                                       000 - 100
ADHOC_EMPL_V     Loa Rtn Dt            The estimated or actual date the employee returns from leave.                                         DATE                  01/01/01 12:00 AM                             ISI_EDB_BAS,   LOARETDT,
                                       10-character alphanumeric (maximum).                                                                                                                                      NYU_EDB_EMP    LOA_RTN_DT
                                       Valid formats are:
                                       MMDDYYYY
                                       MM DD YYYY
                                       MM/DD/YYYY
                                       MM-DD-YYYY
                                       MM.DD.YYYY
ADHOC_EMPL_V     Loa Srv Ind           Indicates whether the leave counts towards tenure and/or sabbatical, as applicable.                   VARCHAR2            1 Y                                             NYU_EDB_EMP    LOA_SRV_IND
                                       Optional.
                                       1-character alphanumeric.
                                       Valid codes: Y or N.
ADHOC_EMPL_V     Loareasn              Indicates the reason for the leave of absence.                                                        VARCHAR2            2 SF - Sabbatical (fall semester)               ISI_EDB_BAS    LOAREASN              CL - Child care                                    IL - Illness/disability (non-faculty)                    OA - Other (faculty: academic year)               PL - Personal (non-faculty)
                                                                                                                                                                                                                                                      DL - Long term disability                          IS - Illness/disability (faculty: spring semester)       OF - Other (faculty: fall semester)               PS - Personal (faculty: spring semester)
                                                                                                                                                                                                                                                      FC - FMLA leave (child care)                       MA - Military (faculty: academic year)                   OL - Other (non-faculty)                          SA - Sabbatical (academic year)
                                                                                                                                                                                                                                                      FF - FMLA leave (medical - family)                 MF - Military (faculty: fall semester)                   OS - Other (faculty: spring semester)             SF - Sabbatical (fall semester)
                                                                                                                                                                                                                                                      FS - FMLA leave (medical - self)                   ML - Military (non-faculty)                              PA - Personal (faculty: academic year)            SS - Sabbatical (spring semester)
                                                                                                                                                                                                                                                      IA - Illness/disability (faculty: academic year)   MS - Military (faculty: spring semester)                 PF - Personal (faculty: fall semester)            UL - University requested leave
                                                                                                                                                                                                                                                      IF - Illness/disability (faculty: fall semester)


ADHOC_EMPL_V     Smstrs Int Srv No     The number of semesters of leave to be counted as interruption to years of service.                   INTEGER               0                                             NYU_EDB_EMP    SMSTRS_INT_SRV_NO
                                       2-digit numeric.




                                                                                                                                                                                                                                                                                                                                                                                                                                                          Page 5 of 28
                                                                                                                                                                                         07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                  Field                                              Description                                              Data Type   Length Example                                           Source Table        Source Field                     Additional Info 1                  Additional Info 2              Additional Info 3   Additional Info 4
ADHOC_EMPL_V     Sepreasn               Indicates the reason for separation.                                                               VARCHAR2           2 12 - Non-reappointment                        ISI_EDB_BAS       SEPREASN             01 - Terminated during probation     11 - Temporary employment ended
                                                                                                                                                                                                                                                     02 - Termination                     12 - Non-reappointment
                                                                                                                                                                                                                                                     03 - Death                           13 - Canceled
                                                                                                                                                                                                                                                     04 - Retirement                      14 - Other
                                                                                                                                                                                                                                                     05 - Illness disability              15 - Quit without notice (during probation)
                                                                                                                                                                                                                                                     06 - Layoff                          16 - Change to non-permanent
                                                                                                                                                                                                                                                     07 - Resigned during probation       18 - Expired document
                                                                                                                                                                                                                                                     08 - Resigned                        20 - Terminated retiree
                                                                                                                                                                                                                                                     09 - Quit without notice             21 - Terminated spouse/dependent
                                                                                                                                                                                                                                                     10 - Transfer to Medical Center      70 - System separation


ADHOC_EMPL_V     Seprtn Dt              Date the employee was separated.                                                                   DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP       SEPRTN_DT
                                        10-character alphanumeric (maximum).
                                        Valid formats:
                                        MMDDCCYY
                                        MM DD CCYY
                                        MM/DD/CCYY
                                        MM-DD-CCYY
                                        MM.DD.CCYY
ADHOC_EMPL_V     Rtrmnt Dt              The effective date of retirement of the employee. Maintained by Benefits only.                     DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP       RTRMNT_DT
                                        10-character alphanumeric (maximum).
                                        Valid formats:
                                        MMDDCCYY
                                        MM DD CCYY
                                        MM/DD/CCYY
                                        MM-DD-CCYY
                                        MM.DD.CCYY
ADHOC_EMPL_V     Svrnc Due Pay Amt      The dollar amount due as severance pay at the time of separation.                                  NUMBER           9,2 0                                             NYU_EDB_EMP       SVRNC_DUE_PAY_AMT
                                        9-digit numeric.
                                        Valid format: 9999999.99
ADHOC_EMPL_V     Vctn Due Hrs           The vacation hours due at time of separation.                                                      NUMBER           5,2 0                                             NYU_EDB_EMP       VCTN_DUE_HRS
                                        5-digit numeric.
                                        Valid format: 999.99.
ADHOC_EMPL_V     Rehire                 For terminated employees only. Indicates whether the terminated employee is eligible for rehire.   VARCHAR2           1                                               ISI_EDB_BAS       REHIRE
                                        1-character alphanumeric.
                                        Valid codes:
                                        Blank - Active employees
                                        N - Not eligible for rehire
                                        Y - Eligible for rehire


ADHOC_EMPL_V     Spclstat               Indicates the tenure status of faculty members.                                                    VARCHAR2           1 T - Tenured                                   ISI_EDB_BAS       SPCLSTAT
                                        1-character alphanumeric.
                                        Valid codes:
                                        Blank - No special status or not applicable
                                        E - Tenure-eligible
                                        N - Not eligible for tenure
                                        T - Tenured
                                        X-
ADHOC_EMPL_V     Tenr Stts Dt           The effective date of the tenure status of the faculty member.                                     DATE                   01/01/01 12:00 AM
ADHOC_EMPL_V     Instrctr Dt            The date when the employee achieved the rank of Instructor.                                        DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP       INSTRCTR_DT
                                        Optional.
                                        5-character alphanumeric (maximum).
                                        Valid formats are:
                                        MMYY
                                        MM/YY
ADHOC_EMPL_V     Asstnt Dt              The date when the employee achieved the rank of Assistant Professor.                               DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP       ASSTNT_DT
                                        Optional.
                                        5-character alphanumeric (maximum).
                                        Valid formats are:
                                        MMYY
                                        MM/YY
ADHOC_EMPL_V     Asscte Dt              The date when the employee achieved the rank of Associate Professor.                               DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP       ASSCTE_DT
                                        Optional.
                                        5-character alphanumeric (maximum).
                                        Valid formats are:
                                        MMYY
                                        MM/YY
ADHOC_EMPL_V     Prfssr Dt              The date when the employee achieved the rank of Professor.                                         DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP       PRFSSR_DT
                                        Optional.
                                        5-character alphanumeric (maximum).
                                        Valid formats are:
                                        MMYY
                                        MM/YY
ADHOC_EMPL_V     Prvsrv For Tnr Ind     Indicates whether previous service has been a consideration in tenure decisions.                   VARCHAR2           1 Y - Qualifying service                        NYU_EDB_EMP       PRVSRV_FOR_TNR_IND
                                        1-position alpha.
                                        Values: N - No qualifying service
                                        Y - Qualifying service
                                        V - Qualifying service not confirmed (verify)
ADHOC_EMPL_V     Senrtydt               The date from which the years of service for the employee are calculated.                          DATE                   01/01/01 12:00 AM                           ISI_EDB_BAS       SENRTYDT
                                        10-character alphanumeric (maximum).
                                        Valid formats:
                                        MMDDCCYY
                                        MM DD CCYY
                                        MM/DD/CCYY
                                        MM-DD-CCYY
                                        MM.DD.CCYY
ADHOC_EMPL_V     Service Award No       Indicates the service year milestone the employee has achieved.                                    INTEGER                0



                                                                                                                                                                                                                                                                                                                                                                      Page 6 of 28
                                                                                                                                                                                          07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                 Field                                                 Description                                            Data Type   Length Example                                           Source Table         Source Field                  Additional Info 1                        Additional Info 2                 Additional Info 3                                            Additional Info 4
ADHOC_EMPL_V     Fmlaenti              Not used.                                                                                          NUMBER            5,2 0
ADHOC_EMPL_V     Fmlabegd              Not used.                                                                                          DATE                  01/01/01 12:00 AM
ADHOC_EMPL_V     Netid                 Idientifies the university NetId of the employee.                                                  VARCHAR2           16 JD00
ADHOC_EMPL_V     Chk Lctn Cd           Check location code                                                                                VARCHAR2            2 01
ADHOC_EMPL_V     Longevity Cd          A code identifying the longevity tier achieved (for bargaining unit eligible jobs).                CHAR               10
ADHOC_EMPL_V     Perfrtng              The performance rating for an employee related to their primary appointment.                       INTEGER
ADHOC_EMPL_V     Vol Invol Ind         Voluntary/Involuntary separation indicator.                                                        CHAR               1
ADHOC_EMPL_V     Ui Challenge Ind      Unemployment Insurance challenge indicator.                                                        CHAR               1
ADHOC_PERS_V     Emplkey               System generated employee key used to join adhoc views for query purposes                          VARCHAR2          35
ADHOC_PERS_V     Orgid                 Active employees are stored in the Active Org which is OrgID=blank; Retirees are in the RET org    VARCHAR2          13 <blank> or <RET>
                                       with OrgID=RET.
ADHOC_PERS_V     Nyuid                 University ID - System generated employee identification number used to uniquely identify          VARCHAR2          11 N12345678
                                       employees and is not the same as the employee social security number.
ADHOC_PERS_V     Homedept              Primary (home) department of an employee (department of the primary appointment). Jobdept is       VARCHAR2            8 56210                                          ISI_EDB_BAS      HOMEDEPT
                                       the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                       Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

ADHOC_PERS_V     Object Cd             Identifies the general type of work performed and the full-time/part-time status for the PRIMARY   INTEGER                 100 - Admin/professional (FT)                NYU_EDB_EMP_T OBJECT_CD                                                                                           JOB_OBJECT_CD (OBJECT_CD on                       100 - Admin/professional (FT)
                                       (job #1) assignment of the employee.                                                                                       102 - Faculty (FT)                                                                 110 - Admin/professional (PT)                                               NYU_EDB_JOB_T) is the object code of the          101 - Teaching or graduate assistant (FT)
                                                                                                                                                                                                                                                     111 - Grader, tutor, lab assistant (PT)   118 - Student (workstudy)         particular job. Use the Object Code from the      102 - Faculty (FT)
                                                                                                                                                                                                                                                     112 - Faculty (PT)                        119 - Student (non-workstudy)     Emp_T table if you are looking at primary         103 - Professional researcher (FT)
                                                                                                                                                                                                                                                     113 - Professional researcher (PT)        130 - Research assistant (FT)     jobs, use the object code from the Job_T          104 - Laboratory/technical staff (FT)
                                                                                                                                                                                                                                                     114 - Laboratory/technical staff (PT)     131 - Research assistant (FT)     table if you are looking at the object codes of   106 - Office/clerical staff (FT)
                                                                                                                                                                                                                                                     115 - Casual employee (PT)                542 - Post-doctoral fellow (FT)   all jobs.                                         107 - Service staff (FT)
                                                                                                                                                                                                                                                     116 - Office/clerical staff (PT)
                                                                                                                                                                                                                                                     117 - Service staff (PT)

ADHOC_PERS_V     Emplstat              Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either       VARCHAR2            1 A
                                       = A,L, P or EMPLSTAT <> T for query/reporting limits.
ADHOC_PERS_V     Emplname              Name of employee.                                                                                  VARCHAR2          30                                                 ISI_EDB_BAS      EMPLNAME
                                       Valid format: Last name, comma, first name, space, middle initial
ADHOC_PERS_V     Namesufx              The suffix that may follow the name of the employee, such as Esq., PhD, III, Jr.                   VARCHAR2            4                                                ISI_EDB_BAS      NAMESUFX
                                       Optional.
                                       4-character alphanumeric.
ADHOC_PERS_V     Nameprfx              The prefix for the name of the employee; such as Mr., Mrs., or Dr.                                 VARCHAR2            4                                                ISI_EDB_BAS      NAMEPRFX
                                       Optional.
                                       4-character alphanumeric.
ADHOC_PERS_V     Sex                   Th sex of the employee.                                                                            CHAR                1 M                                              ISI_EDB_PER      SEX
                                       Valid codes:
                                       F - Female
                                       M - Male
ADHOC_PERS_V     Birthdt               Date of birth of the employee.                                                                     DATE                    03/15/80 12:00 AM                            ISI_EDB_PER      BIRTHDT
                                       Required.
                                       10-character alphanumeric (maximum).
                                       Valid formats:
                                       MMDDYYYY
                                       MM DD YYYY
                                       MM/DD/YYYY
                                       MM-DD-YYYY
                                       MM.DD.YYYY

ADHOC_PERS_V     Hispanic Ind          A Y/N flag identify whether the employee has identified themselves to be of hispanic origin.       CHAR                1

ADHOC_PERS_V     Race1 Ind             A code identifying the identified ethnicity of the employee.                                       CHAR               1
ADHOC_PERS_V     Race2 Ind             See RACE1_IND (employee may identify multiple ethnicities).                                        CHAR               1
ADHOC_PERS_V     Race3 Ind             See RACE1_IND (employee may identify multiple ethnicities).                                        CHAR               1
ADHOC_PERS_V     Race4 Ind             See RACE1_IND (employee may identify multiple ethnicities).                                        CHAR               1
ADHOC_PERS_V     Race5 Ind             See RACE1_IND (employee may identify multiple ethnicities).                                        CHAR               1
ADHOC_PERS_V     Curstr                Current address of employee - street line 1                                                        CHAR              30
ADHOC_PERS_V     Curcity               Current address of employee - city                                                                 CHAR              30
ADHOC_PERS_V     Curstate              Current address of employee - state                                                                CHAR               2
ADHOC_PERS_V     Curzip                Current address of employee - postal code                                                          CHAR              10
ADHOC_PERS_V     Nyu Province          Alternate address - province                                                                       CHAR              30
ADHOC_PERS_V     Nyu Postal Cd         Alternate address - postal code                                                                    CHAR              30
ADHOC_PERS_V     Nyu Phone No          Alternate address - phone number                                                                   CHAR              30
ADHOC_PERS_V     Aacity                Alternate address - city                                                                           CHAR              30
ADHOC_PERS_V     Aacntry               Alternate address - country                                                                        CHAR               3
ADHOC_PERS_V     Aastr2                Alternate address - street field 3                                                                 CHAR              30
ADHOC_PERS_V     Aastreet              Alternate address - street field 2                                                                 CHAR              30
ADHOC_PERS_V     Nyu Aastr3            Alternate address - street field 4                                                                 CHAR              30
ADHOC_PERS_V     Milstat               The military status reported by the employee.                                                      CHAR               1 A - Active reserve                              ISI_EDB_PER      MILSTAT
                                       Blank - Not indicated
                                       A - Active reserve
                                       D - Special disabled veteran
                                       N - Inactive reserve
                                       O - Veteran
                                       R - Retired
                                       S - Special disabled Vietnam veteran
                                       V - Vietnam era veteran

ADHOC_PERS_V     Hmphone               Home area code and telephone number for employee.                                                  NUMBER            11                                                 ISI_EDB_PER      HMPHONE
                                       Optional.
                                       12-character alphanumeric (maximum).
                                       Valid formats:
                                       9999999999
                                       999/999-9999




                                                                                                                                                                                                                                                                                                                                                                                                                      Page 7 of 28
                                                                                                                                                                                               07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                       Field                                           Description                                                  Data Type   Length Example                                           Source Table       Source Field                  Additional Info 1                             Additional Info 2                               Additional Info 3                                            Additional Info 4
ADHOC_PERS_V             Wkphone             Area code and telephone number at work for employee.                                                NUMBER           11                                                ISI_EDB_PER       WKPHONE
                                             Optional.
                                             12-character alphanumeric (maximum).
                                             Valid formats:
                                             9999999999
                                             999/999-9999
ADHOC_PERS_V             Wrkdept             Work department of employee.                                                                        CHAR              8
ADHOC_PERS_V             Altaddfl            Alternate address field indicator. A value of Y indicates the employee has submitted an alternate   CHAR              1
                                             address to Payroll for W-2 mailing.
ADHOC_PERS_V             Statusdt            The effective date of the Employment Status (see Emplstat) of an employee.                          DATE                09/01/05 12:00 AM
ADHOC_NYUIDS_MISSING_V   Emplkey             System generated employee key used to join adhoc views for query purposes                           VARCHAR2         35
ADHOC_NYUIDS_MISSING_V   Nyuid               University ID - System generated employee identification number used to uniquely identify           VARCHAR2         11 N12345678
                                             employees and is not the same as the employee social security number.
ADHOC_NYUIDS_MISSING_V   EMPLNAME            Name of employee.                                                                                   VARCHAR2         30                                                ISI_EDB_BAS       EMPLNAME
                                             Valid format: Last name, comma, first name, space, middle initial
ADHOC_NYUIDS_MISSING_V   Netid               Idientifies the university NetId of the employee.                                                   VARCHAR2         16 JD00
ADHOC_NYUIDS_MISSING_V   Homedept            Primary (home) department of an employee (department of the primary appointment). Jobdept is        VARCHAR2          8 56210                                          ISI_EDB_BAS       HOMEDEPT
                                             the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                             Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

ADHOC_NYUIDS_MISSING_V   Unit Name           Hierarchy is Unit -> Dvision -> Department                                                          VARCHAR2         30 DIVISION OF LIBRARIES
ADHOC_NYUIDS_MISSING_V   Div Name            Hierarchy is Unit -> Division -> Department                                                         VARCHAR2         30 DIVISION OF LIBRARIES
ADHOC_NYUIDS_MISSING_V   Dept Name           The code of the department responsible for this job assignment.                                     VARCHAR2         30 RESEARCH DEVELOPMENT                           ISI_EDB_JOB       JOBDEPT
                                             5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                             Use the table look-up feature to find current values and translations.
ADHOC_EMPLOYMENT_V       Emplkey             System generated employee key used to join adhoc views for query purposes                           VARCHAR2         35
ADHOC_EMPLOYMENT_V       Nyuid               University ID - System generated employee identification number used to uniquely identify           VARCHAR2         11 N12345678
                                             employees and is not the same as the employee social security number.
ADHOC_EMPLOYMENT_V       Emplname            Name of employee.                                                                                   VARCHAR2         30                                                ISI_EDB_BAS       EMPLNAME
                                             Valid format: Last name, comma, first name, space, middle initial
ADHOC_EMPLOYMENT_V       Job Ttl 1           The job assignment title for this job assignment.                                                   CHAR             30 DEVELOPMENT COMMUNICATIONS MAN                 NYU_EDB_JOB       JOB_TTL_1
                                             60-character alphanumeric (stored as two 30-position fields).
ADHOC_EMPLOYMENT_V       Job Ttl 2           The job assignment title for this job assignment.                                                   CHAR             30 AGER                                           NYU_EDB_JOB       JOB_TTL_2
                                             60-character alphanumeric (stored as two 30-position fields).
ADHOC_EMPLOYMENT_V       Jobdept             Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be        VARCHAR2          8 43020                                          ISI_EDB_JOB       JOBDEPT
                                             from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                             Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
ADHOC_EMPLOYMENT_V       Dept Name           The code of the department responsible for this job assignment.                                     VARCHAR2         30 RESEARCH DEVELOPMENT                           ISI_EDB_JOB       JOBDEPT
                                             5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                             Use the table look-up feature to find current values and translations.
ADHOC_EMPLOYMENT_V       Homedept            Primary (home) department of an employee (department of the primary appointment). Jobdept is VARCHAR2                 8 56210                                          ISI_EDB_BAS       HOMEDEPT
                                             the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                             Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

ADHOC_EMPLOYMENT_V       Jobno               JobNo is the physical number of the job in the database; Prty_Cd is the assigned priority of the    DATE                  1                                            ISI_EDB_JOB,      JOBNO
                                             job. JobNo gets reset nightly to match Prty_Cd. Use Prty_Cd instead of JobNo. An employee                                                                              ISI_EDB_ACC,
                                             can have up to 7 jobs. Job #7 is for Payroll use only.                                                                                                                 NYU_EDB_JOB,
                                                                                                                                                                                                                    NYU_EDB_ACT
ADHOC_EMPLOYMENT_V       Prty Cd             Priority code of 1 should be assigned to the primary job assignment. An employee can have up to INTEGER                   1                                            NYU_EDB_JOB       PRTY_CD
                                             7 jobs and must have one appointment with priority 1. No two appointments may have the same
                                             priority. Job priority 7 is for Payroll use only.
ADHOC_EMPLOYMENT_V       Emplmtdt            Employment date. Generally this date is updated when an employee moves into/out of a benefits- DATE                       09/01/05 12:00 AM
                                             eligible assignment.
ADHOC_EMPLOYMENT_V       Object Cd           Identifies the general type of work performed and the full-time/part-time status for the PRIMARY INTEGER                  100 - Admin/professional (FT)                NYU_EDB_EMP_T OBJECT_CD                                                                                                             JOB_OBJECT_CD (OBJECT_CD on                       100 - Admin/professional (FT)
                                             (job #1) assignment of the employee.                                                                                      102 - Faculty (FT)                                                                110 - Admin/professional (PT)                                                                  NYU_EDB_JOB_T) is the object code of the          101 - Teaching or graduate assistant (FT)
                                                                                                                                                                                                                                                         111 - Grader, tutor, lab assistant (PT)        118 - Student (workstudy)                       particular job. Use the Object Code from the      102 - Faculty (FT)
                                                                                                                                                                                                                                                         112 - Faculty (PT)                             119 - Student (non-workstudy)                   Emp_T table if you are looking at primary         103 - Professional researcher (FT)
                                                                                                                                                                                                                                                         113 - Professional researcher (PT)             130 - Research assistant (FT)                   jobs, use the object code from the Job_T          104 - Laboratory/technical staff (FT)
                                                                                                                                                                                                                                                         114 - Laboratory/technical staff (PT)          131 - Research assistant (FT)                   table if you are looking at the object codes of   106 - Office/clerical staff (FT)
                                                                                                                                                                                                                                                         115 - Casual employee (PT)                     542 - Post-doctoral fellow (FT)                 all jobs.                                         107 - Service staff (FT)
                                                                                                                                                                                                                                                         116 - Office/clerical staff (PT)
                                                                                                                                                                                                                                                         117 - Service staff (PT)

ADHOC_EMPLOYMENT_V       Job Object Cd       JOB_OBJECT_CD identifies the general type of work performed and the full-time part-time status INTEGER                    100 - Admin/professional (FT)                NYU_EDB_JOB_T     OBJECT_CD          OBJECT_CD, which is listed as field            Use the Object Code from the Emp_T table if
                                             for a particular job of an employee; based on the Jobno or Prty Cd of the record.                                         102 - Faculty (FT)                                                                OBJECT_CD on the NYU_EDB_EMP_T table,          you are only looking at primary jobs, use the
                                                                                                                                                                                                                                                         is the object code of the primary job and is   object code from the Job_T table if you are
                                                                                                                                                                                                                                                         defaulted from the Object Code of Job #1.      looking at the object codes of all jobs.

ADHOC_EMPLOYMENT_V       Range               A numeric salary ranking assigned to most administrative, technical and clerical assignments;       VARCHAR2          2 OC 104, 114 -> Grade Blank; 40 - 45            ISI_EDB_JOB       RANGE                                                             OC 101, 111, 102, 112, 103, 113, 115, 118,
                                             known as the grade of the job.                                                                                                                                                                                                                             119, 107, 117, 130, 131, 542 -> Grade Blank
                                                                                                                                                                                                                                                                                                        OC 100, 110 -> Grade Blank; 11 - 21
                                                                                                                                                                                                                                                                                                        OC 104, 114 -> Grade Blank; 40 - 45
                                                                                                                                                                                                                                                                                                        OC 106, 116 -> Grade Blank; 1, 2, 3, 5 - 10



ADHOC_EMPLOYMENT_V       Emplstat            Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either        VARCHAR2          1 A
                                             = A,L, P or EMPLSTAT <> T for query/reporting limits.
ADHOC_EMPLOYMENT_V       Regtemp             Indicates whether the primary job assignment of the employee is regular or temporary.               VARCHAR2          1 R - Regular                                    ISI_EDB_BAS       REGTEMP
                                             Valid codes:
                                             R - Regular
                                             T - Temporary
ADHOC_EMPLOYMENT_V       Aptbegdt            The date this job assignment or appointment is effective.                                           DATE                  09/01/05 12:00 AM                            ISI_EDB_JOB       APTBEGDT                                                          To set the limit to get active appointments                                                       Valid formats:
                                             The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                        only                                                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                                          - Use APTBEGDT < sysdate and                                                                    MM DD YYYY
                                                                                                                                                                                                                                                                                                        APTENDDT > sysdate                                                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                                        To identify cancelled appointments:                                                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                                          - APTBEGDT = APTENDDT and                                                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                                        APPT_AMT = 1




                                                                                                                                                                                                                                                                                                                                                                                                                                             Page 8 of 28
                                                                                                                                                                                              07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                     Field                                            Description                                                   Data Type   Length Example                                          Source Table        Source Field                   Additional Info 1                                 Additional Info 2                                       Additional Info 3                                           Additional Info 4
ADHOC_EMPLOYMENT_V   Aptenddt              The date this job assignment or appointment ends.                                                     DATE                12/31/99 12:00 AM                             ISI_EDB_JOB       APTENDDT                                                               To set the limit to get active appointments                                                               Valid formats:
                                           The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                              only                                                                                                      MMDDYYYY
                                                                                                                                                                                                                                                                                                              - Use APTBEGDT < sysdate and                                                                            MM DD YYYY
                                                                                                                                                                                                                                                                                                            APTENDDT > sysdate                                                                                        MM/DD/YYYY
                                                                                                                                                                                                                                                                                                            To identify cancelled appointments:                                                                       MM-DD-YYYY
                                                                                                                                                                                                                                                                                                              - APTBEGDT = APTENDDT and                                                                               MM.DD.YYYY
                                                                                                                                                                                                                                                                                                            APPT_AMT = 1
ADHOC_EMPLOYMENT_V   Jobclass              The job classification code assigned to this job assignment.                                          VARCHAR2          6 220163                                        ISI_EDB_JOB       JOBCLASS
                                           Can be decoded using HR.ISI_CDB_JOB_T table.
                                           6-character alphanumeric.
                                           Use the table look-up feature to find current values and translations.
ADHOC_EMPLOYMENT_V   Jobtitle              The job assignment title for this job assignment.                                                    VARCHAR2          60 DEVELOPMENT COMMUNICATIONS MANAGER            NYU_EDB_JOB       JOB_TTL_1,
                                           60-character alphanumeric (concatenated in this view, but stored as two 30-position fields Job Ttl 1                                                                                      JOB_TTL_2
                                           and Job Ttl 2 in the source table).
ADHOC_EMPLOYMENT_V   Appt Amt              This field is calculated based on PAY TERM, PAY RATE, and PAY CYCLE. Appt Amount is stored NUMBER                      9,3 30,000.00                                    NYU_EDB_JOB       APPT_AMT            This field is calculated based on PAY TERM,        OC 100,110 -> B1 pay cycle -> any pay term -             When ApptAmt=$1.00, employee will not be         OC 102,112,103,113 -> 22,92 pay term -> appt amt = PAY RATE x
                                           as annual base, monthly pay, weekly pay, gross pay during period of appointment, etc based on                                                                                                                 PAY RATE, and PAY CYCLE.                           > appt amt = PAY RATE x 26                               paid. Either: 1) person has an affiliated appt   12
                                           different object codes.                                                                                                                                                                                       OC 104,114,106 -> any pay cycle -> any pay         OC 115,118,119 -> any pay cycle -> any pay               but does not get paid by NYU, 2) Person on       OC 102,112,103,113 -> 96 pay term -> appt amt = PAY RATE x 6
                                                                                                                                                                                                                                                         term -> appt amt = PAY RATE x work hours           term -> appt amt = PAY RATE                              an unpaid leave of absence, 3) appt is           OC 102,112,103,113 -> 97 pay term -> appt amt = PAY RATE x 7
                                                                                                                                                                                                                                                         OC 116,107,117, 100, 110 -> M1 paycycle ->         OC 102,112,103,113 -> any pay cycle -> 01-               cancelled (ApptAmt=$1.00 AND the Appt            OC 102,112,103,113 -> 98 pay term -> appt amt = PAY RATE x 9
                                                                                                                                                                                                                                                         any pay term -> appt amt = PAY RATE x 12           11 pay term -> appt amt = PAY RATE x PAY                 Begin Date=Appt End Date)
                                                                                                                                                                                                                                                                                                            TERM


ADHOC_EMPLOYMENT_V   Fctly Bse Sal Amt     The annualized salary of the primary appointment. Although this is labeled Faculty base, this field   NUMBER           9,2 30,000                                       NYU_EDB_EMP       FCTLY_BSE_SAL_AMT   OC 104,114,106 -> any pay cycle/term -> base       OC 103 -> any pay cycle/term -> base salary              Does not include administrative stipend or       OC 102 -> any pay cycle -> 96 pay term -> base salary = PAY RATE
                                           is populated not only for code 102s, but 103s, 113s, 100s and 110s.                                                                                                                                           salary = PAY RATE x work hours x 52                = PAY RATE x 12                                          additional compensation for miscellaneous        x 12
                                                                                                                                                                                                                                                         OC 116,107,117, 100,110 -> M1 pay cycle ->         OC 112,113,118 -> any pay cycle/term -> no               short-term assignments.                          OC 102 -> any pay cycle -> 97 pay term -> base salary =PAY RATE
                                                                                                                                                                                                                                                         any pay term -> base salary = PAY RATE x 12        BASE SALARY                                                                                               x 14
                                                                                                                                                                                                                                                         OC 100,110 -> B1 pay cycle -> any pay term ->      OC 119, 102 -> any pay cycle -> 92 pay term          -
                                                                                                                                                                                                                                                         base salary = PAY RATE x 26                        > base salary = PAY RATE x 12



ADHOC_EMPLOYMENT_V   Bldng Cd              Work Location of employee - Building Name                                                             VARCHAR2          5 726BW
ADHOC_EMPLOYMENT_V   Room No               Work Location of employee - Room No                                                                   VARCHAR2          5 7FL
ADHOC_EMPLOYMENT_V   Loa Bgn Dt            The date the leave of absence of the employee begins.                                                 DATE                01/01/01 12:00 AM                             NYU_EDB_EMP       LOA_BGN_DT
                                           10-character alphanumeric (maximum).
                                           Valid formats are:
                                           MMDDYYYY
                                           MM DD YYYY
                                           MM/DD/YYYY
                                           MM-DD-YYYY
                                           MM.DD.YYYY
ADHOC_EMPLOYMENT_V   Loa Rtn Dt            The estimated or actual date the employee returns from leave.                                         DATE                01/01/01 12:00 AM                             ISI_EDB_BAS,      LOARETDT,
                                           10-character alphanumeric (maximum).                                                                                                                                    NYU_EDB_EMP       LOA_RTN_DT
                                           Valid formats are:
                                           MMDDYYYY
                                           MM DD YYYY
                                           MM/DD/YYYY
                                           MM-DD-YYYY
                                           MM.DD.YYYY
ADHOC_EMPLOYMENT_V   Loa Srv Ind           Indicates whether the leave counts towards tenure and/or sabbatical, as applicable.                   VARCHAR2          1 Y                                             NYU_EDB_EMP       LOA_SRV_IND
                                           Optional.
                                           1-character alphanumeric.
                                           Valid codes: Y or N.
ADHOC_EMPLOYMENT_V   Loa Pay Pct           The percent of base pay the employee receives while on leave.                                         DATE                0                                             NYU_EDB_EMP       LOA_PAY_PCT
                                           3-digit numeric.
                                           Formatted 999.
                                           Valid codes:
                                           000 - 100
ADHOC_EMPLOYMENT_V   Loareasn              Indicates the reason for the leave of absence.                                                        VARCHAR2          2 SF - Sabbatical (fall semester)               ISI_EDB_BAS       LOAREASN            CL - Child care                                    IL - Illness/disability (non-faculty)                    OA - Other (faculty: academic year)              PL - Personal (non-faculty)
                                                                                                                                                                                                                                                         DL - Long term disability                          IS - Illness/disability (faculty: spring semester)       OF - Other (faculty: fall semester)              PS - Personal (faculty: spring semester)
                                                                                                                                                                                                                                                         FC - FMLA leave (child care)                       MA - Military (faculty: academic year)                   OL - Other (non-faculty)                         SA - Sabbatical (academic year)
                                                                                                                                                                                                                                                         FF - FMLA leave (medical - family)                 MF - Military (faculty: fall semester)                   OS - Other (faculty: spring semester)            SF - Sabbatical (fall semester)
                                                                                                                                                                                                                                                         FS - FMLA leave (medical - self)                   ML - Military (non-faculty)                              PA - Personal (faculty: academic year)           SS - Sabbatical (spring semester)
                                                                                                                                                                                                                                                         IA - Illness/disability (faculty: academic year)   MS - Military (faculty: spring semester)                 PF - Personal (faculty: fall semester)           UL - University requested leave
                                                                                                                                                                                                                                                         IF - Illness/disability (faculty: fall semester)


ADHOC_EMPLOYMENT_V   Sepreasn              Indicates the reason for separation.                                                                  VARCHAR2          2 12 - Non-reappointment                        ISI_EDB_BAS       SEPREASN            01 - Terminated during probation                   11 - Temporary employment ended
                                                                                                                                                                                                                                                         02 - Termination                                   12 - Non-reappointment
                                                                                                                                                                                                                                                         03 - Death                                         13 - Canceled
                                                                                                                                                                                                                                                         04 - Retirement                                    14 - Other
                                                                                                                                                                                                                                                         05 - Illness disability                            15 - Quit without notice (during probation)
                                                                                                                                                                                                                                                         06 - Layoff                                        16 - Change to non-permanent
                                                                                                                                                                                                                                                         07 - Resigned during probation                     18 - Expired document
                                                                                                                                                                                                                                                         08 - Resigned                                      20 - Terminated retiree
                                                                                                                                                                                                                                                         09 - Quit without notice                           21 - Terminated spouse/dependent
                                                                                                                                                                                                                                                         10 - Transfer to Medical Center                    70 - System separation


ADHOC_EMPLOYMENT_V   Seprtn Dt             Date the employee was separated.                                                                      DATE                01/01/01 12:00 AM                             NYU_EDB_EMP       SEPRTN_DT
                                           10-character alphanumeric (maximum).
                                           Valid formats:
                                           MMDDCCYY
                                           MM DD CCYY
                                           MM/DD/CCYY
                                           MM-DD-CCYY
                                           MM.DD.CCYY




                                                                                                                                                                                                                                                                                                                                                                                                                                                          Page 9 of 28
                                                                                                                                                                                             07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                  Field                                               Description                                                 Data Type   Length Example                                           Source Table        Source Field                   Additional Info 1                                Additional Info 2                               Additional Info 3                                             Additional Info 4
ADHOC_EMPLOYMENT_V   Spclstat           Indicates the tenure status of faculty members.                                                        VARCHAR2           1 T - Tenured                                   ISI_EDB_BAS       SPCLSTAT
                                        1-character alphanumeric.
                                        Valid codes:
                                        Blank - No special status or not applicable
                                        E - Tenure-eligible
                                        N - Not eligible for tenure
                                        T - Tenured
                                        X-
ADHOC_EMPLOYMENT_V   Tenr Stts Dt       The effective date of the tenure status of the faculty member.                                         DATE                 01/01/01 12:00 AM
ADHOC_EMPLOYMENT_V   Job Fmly Cd        This code identifies the general functional responsibility of this job assignment.                     CHAR               1 A - Administrative services                   NYU_EDB_JOB       JOB_FMLY_CD         1 - Finance                                        A - Administrative services                    G - General administrative support                 Q - Admissions, registration, and financial aid
                                                                                                                                                                                                                                                        2 - Communications                                 B - Sergeant guards (for object code 107,      K - Communications                                 S - Survivors of retirees
                                                                                                                                                                                                                                                        3 - Institutional facilities                       117)                                           L - Library, technical, and data processing (for   T - Animal, dental/medical, media lab technicians
                                                                                                                                                                                                                                                        4 - Administrative services                        C - Elevator starters (for object code 107,    object code 100, 110)                              X - Academic administrators not in plan
                                                                                                                                                                                                                                                        5 - Student affairs                                117)                                           L - Comp, equip fab, general technical             Z - Student affairs
                                                                                                                                                                                                                                                        6 - Admissions, registration, and financial aid    D - Academic support (for object code 100,     support (for object code 104, 114)
                                                                                                                                                                                                                                                        7 - Library, technical, and data processing        110)                                           N - Institutional facilities
                                                                                                                                                                                                                                                        8 - Academic support                               D - Cdl, dental equipment repair technicians
                                                                                                                                                                                                                                                                                                           (for object code 104, 114)
                                                                                                                                                                                                                                                                                                           F - Finance

ADHOC_EMPLOYMENT_V   Emp Ctgy Cd        The employee category associated with this job assignment which identifies a grouping of similar       VARCHAR2           1 F - Faculty                                   NYU_EDB_JOB       EMP_CTGY_CD         A - Administrative and Professional                N - Student
                                        jobs for reporting purposes.                                                                                                                                                                                    D - Post-Doctoral Fellows                          R - Professional Researcher
                                                                                                                                                                                                                                                        F - Faculty                                        S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                                        G - Unpaid appointments                            T - Casual employees
                                                                                                                                                                                                                                                        K - Graduate, Research, and Teaching               X - University Officers
                                                                                                                                                                                                                                                        Assistants                                         Z - Retired employees
                                                                                                                                                                                                                                                        M - Management, Directors and Academic
                                                                                                                                                                                                                                                        Administrators
ADHOC_EMPLOYMENT_V   Orgid              Active employees are stored in the Active Org which is OrgID=blank; Retirees are in the RET org        VARCHAR2          13 <blank> or <RET>
                                        with OrgID=RET.
ADHOC_EMPLOYMENT_V   Qtrno              Quarter Number - The field qtrno should be =0 in most queries but in the actual table in HRIS it can                          0
                                        also be a 4 (for tax purposes).
ADHOC_EMPLOYMENT_V   Socsecno           Social Security Number of employee                                                                     INTEGER              111223333
ADHOC_EMPLOYMENT_V   Addlssn            Not used.                                                                                              CHAR              10
ADHOC_EMPLOYMENT_V   Sex                Th sex of the employee.                                                                                CHAR               1 M                                             ISI_EDB_PER       SEX
                                        Valid codes:
                                        F - Female
                                        M - Male
ADHOC_EMPLOYMENT_V   Birthdt            Date of birth of the employee.                                                                         DATE                   03/15/80 12:00 AM                           ISI_EDB_PER       BIRTHDT
                                        Required.
                                        10-character alphanumeric (maximum).
                                        Valid formats:
                                        MMDDYYYY
                                        MM DD YYYY
                                        MM/DD/YYYY
                                        MM-DD-YYYY
                                        MM.DD.YYYY

ADHOC_EMPLOYMENT_V   Ethnicty           No longer used (see ETHNICITY_RACE).                                                                   CHAR               1 A - Native American/Amerind/Alaskan native    ISI_EDB_PER       ETHNICTY                                                               If the CNTRY code of the Organization Table                                                       Blank - Not indicated
                                                                                                                                                                                                                                                                                                           entry for this ORG is CAN, the ETHNICITY                                                          A - Native American/Amerind/Alaskan native
                                                                                                                                                                                                                                                                                                           must be 1, 2, 3, 4, or blank. Otherwise, it                                                       B - Black/African-American
                                                                                                                                                                                                                                                                                                           must be A, B, C, R, S, or blank.                                                                  C - Caucasian/White
                                                                                                                                                                                                                                                                                                                                                                                                             R - Asian/Pacific islander
                                                                                                                                                                                                                                                                                                                                                                                                             S - Hispanic/Latino
ADHOC_EMPLOYMENT_V   Ctznvisa           Indicates U.S. citizenship, immigrant status, or type of visa held by the employee.                    CHAR               2 US                                            ISI_EDB_PER       CTZNVISA            A1 - Diplomatic and government officials (high                                                                                                       J1 - Exchange visitor
                                                                                                                                                                                                                                                        level)                                             G1/2/3/4 - Representatives to international                                                       J2 - Spouse or child of an exchange visitor
                                                                                                                                                                                                                                                        A2 - Diplomatic and government officials (lesser   organizations and their families                                                                  O1 - Extraordinary ability
                                                                                                                                                                                                                                                        rank)                                              H1 - Temporary worker - professional or                                                           O2 - Extraordinary support
                                                                                                                                                                                                                                                        E1 - Treaty trader                                 skilled                                                                                           TN - Canadian/Mexican national
                                                                                                                                                                                                                                                        E2 - Treaty investor                               H2 - Temporary worker - general labor                                                             TR - Temporary resident
                                                                                                                                                                                                                                                        EA - Employment Authorization card                 H3 - Temporary worker - trainee                                                                   US - U.S. citizen
                                                                                                                                                                                                                                                        F1 - Student                                       IM - Immigrant


ADHOC_EMPLOYMENT_V   Ctzncnty           Current country of citizenship (if other than U.S.).                                                   CHAR               3                                               ISI_EDB_PER       CTZNCNTY
                                        Conditionally required.
                                        2-character alphanumeric.
                                        Valid codes are assigned by the federal government.
                                        Use the table look-up feature to find current values and translations.
ADHOC_EMPLOYMENT_V   Visaexdt           The expiration date of the visa for the employee, if any.                                              DATE                   01/01/01 12:00 AM                           ISI_EDB_PER       VISAEXDT
                                        Conditionally required.
                                        Date.
                                        Valid formats:
                                        MMDDYYYY
                                        MM DD YYYY
                                        MM/DD/YYYY
                                        MM-DD-YYYY
                                        MM.DD.YYYY

ADHOC_EMPLOYMENT_V   Educlvl            The highest level of education completed or degree achieved by the employee.                           CHAR               2 MA - Masters degree                           ISI_EDB_PER       EDUCLVL             Blank - Not indicated                              HS - High school
                                                                                                                                                                                                                                                        AA - Associate degree                              JD - Juris doctor
                                                                                                                                                                                                                                                        AS - Associate degree                              LD - Doctor of law
                                                                                                                                                                                                                                                        BA - Bachelors degree                              LM - Master of laws
                                                                                                                                                                                                                                                        BS - Bachelors degree                              MA - Masters degree
                                                                                                                                                                                                                                                        CO - Some college                                  MB - Master of business administration
                                                                                                                                                                                                                                                        DD - Doctor of dentistry                           MD - Doctor of medicine
                                                                                                                                                                                                                                                        DR - Other doctorate (Ed.D.)                       MS - Masters degree
                                                                                                                                                                                                                                                        EN - Engineering degree                            NI - Not indicated
                                                                                                                                                                                                                                                        GS - Less than HS diploma                          PH - Ph.D.
                                                                                                                                                                                                                                                                                                           TC - Trade certificate




                                                                                                                                                                                                                                                                                                                                                                                                                                                Page 10 of 28
                                                                                                                                                                                          07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                  Field                                           Description                                                      Data Type   Length Example                                       Source Table        Source Field                  Additional Info 1                              Additional Info 2                 Additional Info 3                           Additional Info 4
ADHOC_EMPLOYMENT_V   Educlvyr           The year the employee achieved the education level specified in the EDUC LEVEL field.                   DATE                1992                                       ISI_EDB_PER       EDUCLVYR
                                        Optional.
                                        4-digit numeric.
                                        Valid format: YYYY
ADHOC_EMPLOYMENT_V   Milstat            The military status reported by the employee.                                                           CHAR              1 A - Active reserve                         ISI_EDB_PER       MILSTAT
                                        Blank - Not indicated
                                        A - Active reserve
                                        D - Special disabled veteran
                                        N - Inactive reserve
                                        O - Veteran
                                        R - Retired
                                        S - Special disabled Vietnam veteran
                                        V - Vietnam era veteran

ADHOC_EMPLOYMENT_V   Refsrc             Indicates how the employee was referred for employment.                                                 CHAR              1 P                                          ISI_EDB_PER       REFSRC
                                        The first:
                                        Valid codes: D (dept hire) or P (personnel hire)
                                        The second:
                                        Indicates specific source through which the employee learned of the opening.
                                        Valid codes: listed on the Referral Source Table.
ADHOC_EMPLOYMENT_V   Alienrno           Not used.                                                                                               CHAR             10
ADHOC_EMPLOYMENT_V   Langprf            Not used.                                                                                               CHAR              2
ADHOC_EMPLOYMENT_V   Curstr             Current address of employee - street line 1                                                             CHAR             30
ADHOC_EMPLOYMENT_V   Curstr2            Not used.                                                                                               CHAR             30
ADHOC_EMPLOYMENT_V   Curcity            Current address of employee - city                                                                      CHAR             30
ADHOC_EMPLOYMENT_V   Curcnty            Not used.                                                                                               CHAR             20
ADHOC_EMPLOYMENT_V   Curstate           Current address of employee - state                                                                     CHAR              2
ADHOC_EMPLOYMENT_V   Curcntry           Not used.                                                                                               CHAR              3
ADHOC_EMPLOYMENT_V   Curzip             Current address of employee - postal code                                                               CHAR             10
ADHOC_EMPLOYMENT_V   Hmphone            Home area code and telephone number for employee.                                                       NUMBER           11                                            ISI_EDB_PER       HMPHONE
                                        Optional.
                                        12-character alphanumeric (maximum).
                                        Valid formats:
                                        9999999999
                                        999/999-9999
ADHOC_EMPLOYMENT_V   Wkphone            Area code and telephone number at work for employee.                                                    NUMBER           11                                            ISI_EDB_PER       WKPHONE
                                        Optional.
                                        12-character alphanumeric (maximum).
                                        Valid formats:
                                        9999999999
                                        999/999-9999
ADHOC_EMPLOYMENT_V   Wrkdept            Work department of employee.                                                                            CHAR              8
ADHOC_EMPLOYMENT_V   Wrkext             Not used.                                                                                               CHAR              4
ADHOC_EMPLOYMENT_V   Badgeid            Not used.                                                                                               CHAR              6
ADHOC_EMPLOYMENT_V   Altaddfl           Alternate address field indicator. A value of Y indicates the employee has submitted an alternate       CHAR              1
                                        address to Payroll for W-2 mailing.
ADHOC_EMPLOYMENT_V   Emrgcont           Emergency contact person for employee.                                                                  CHAR             30
ADHOC_EMPLOYMENT_V   Contrltn           Emergency contact person for employee - relationship.                                                   CHAR              8
ADHOC_EMPLOYMENT_V   Emrgphon           Emergency contact person for employee - contact number.                                                 NUMBER           11
ADHOC_EMPLOYMENT_V   Bloodtyp           Not used.                                                                                               CHAR              6
ADHOC_EMPLOYMENT_V   Fmlaenti           Not used.                                                                                               NUMBER          5,2 0
ADHOC_EMPLOYMENT_V   Fmlabegd           Not used.                                                                                               DATE                01/01/01 12:00 AM
ADHOC_EMPLOYMENT_V   I9Status           I-9 employment eligibility indicator. A value of Y indicates the employee has an I-9 on file with the   CHAR              1
                                        University.
ADHOC_EMPLOYMENT_V   I9Statdt           The expiration date of the employment eligibility (I-9) status of the employee.                     DATE                      01/01/01 12:00 AM
ADHOC_EMPLOYMENT_V   Unionid            The union code of the employee identifying the bargaining unit of the employee.                     CHAR                  6
ADHOC_EMPLOYMENT_V   Lstindt                                                                                                                DATE
ADHOC_EMPLOYMENT_V   Lstinamt           Not used.                                                                                           NUMBER             11,4
ADHOC_EMPLOYMENT_V   Lstintyp                                                                                                               CHAR                  1
ADHOC_EMPLOYMENT_V   Perfrtng           The performance rating of the employee related to their primary appointment.                        DATE
ADHOC_EMPLOYMENT_V   Prsupv             Not used.                                                                                           CHAR                 30
ADHOC_EMPLOYMENT_V   Minrcd             Indicates whether the database record for employee contains sufficient data for payroll processing. VARCHAR2              1                                            ISI_EDB_BAS       MINRCD              The following data must be present to satisfy   Active Job Assignment - all job assignment                          Valid codes:
                                                                                                                                                                                                                                                     minimum record requirements:                    segments present must have the following                            NO - Minimum data is not present.
                                                                                                                                                                                                                                                     Employee ID                                     fields present and there must be at least one                       OK - Minimum data is present.
                                                                                                                                                                                                                                                     Organization ID                                 job assignment segment.
                                                                                                                                                                                                                                                     Employee Name
                                                                                                                                                                                                                                                     Employment Status
                                                                                                                                                                                                                                                     Active Job Assignment
                                                                                                                                                                                                                                                     Job Class Number
                                                                                                                                                                                                                                                     Rate Code
                                                                                                                                                                                                                                                     Pay Rate
                                                                                                                                                                                                                                                     Job Pay Cycle
                                                                                                                                                                                                                                                     Time Report Code

ADHOC_EMPLOYMENT_V   Namesufx           The suffix that may follow the name of the employee, such as Esq., PhD, III, Jr.                        VARCHAR2          4                                            ISI_EDB_BAS       NAMESUFX
                                        Optional.
                                        4-character alphanumeric.
ADHOC_EMPLOYMENT_V   Nameprfx           The prefix for the name of the employee; such as Mr., Mrs., or Dr.                                      VARCHAR2          4                                            ISI_EDB_BAS       NAMEPRFX
                                        Optional.
                                        4-character alphanumeric.
ADHOC_EMPLOYMENT_V   Phonkey                                                                                                                    VARCHAR2          5
ADHOC_EMPLOYMENT_V   Spclstdt           The date when the employee received or is expected to receive tenure.                                   DATE                                                           ISI_EDB_BAS,      SPCLSTDT,
                                        Date.                                                                                                                                                                  NYU_EDB_EMP       TENR_STTS_DT
                                        Valid formats:
                                        MMDDCCYY
                                        MM DD CCYY
                                        MM/DD/CCYY
                                        MM-DD-CCYY
                                        MM.DD.CCYY




                                                                                                                                                                                                                                                                                                                                                                                                             Page 11 of 28
                                                                                                                                                                                              07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                     Field                                               Description                                              Data Type   Length Example                                           Source Table        Source Field                 Additional Info 1                   Additional Info 2                     Additional Info 3                                      Additional Info 4
ADHOC_EMPLOYMENT_V   Paystat                                                                                                                   VARCHAR2           1
ADHOC_EMPLOYMENT_V   Rehire                Rehire eligible indicator.                                                                          VARCHAR2           1
ADHOC_EMPLOYMENT_V   Senrtydt              The date from which the years of service for the employee are calculated.                           DATE                 01/01/01 12:00 AM                              ISI_EDB_BAS      SENRTYDT
                                           10-character alphanumeric (maximum).
                                           Valid formats:
                                           MMDDCCYY
                                           MM DD CCYY
                                           MM/DD/CCYY
                                           MM-DD-CCYY
                                           MM.DD.CCYY
ADHOC_EMPLOYMENT_V   Partfull              Indicates whether the employee is full time or part time.                                           VARCHAR2           1 F
                                           Valid codes:
                                           F - Full
                                           P - Part
ADHOC_EMPLOYMENT_V   Empltype                                                                                                                  VARCHAR2          1
ADHOC_EMPLOYMENT_V   Fromxorg              If the employee has been transferred to the RET (retiree) organization, this field indicates RET.   VARCHAR2         13                                                 ISI_EDB_BAS      FROMXORG

ADHOC_EMPLOYMENT_V   Fromxid               If the ID of the employee has been changed, this field indicates the prior ID.                      VARCHAR2           9                                                ISI_EDB_BAS      FROMXID
ADHOC_EMPLOYMENT_V   Toxid                 Displays new ID if ID has been changed or when employee transfers between organizations.            VARCHAR2           9                                                ISI_EDB_BAS      TOXID

ADHOC_EMPLOYMENT_V   Lvaccdt                                                                                                                   DATE                   01/01/01 12:00 AM
ADHOC_EMPLOYMENT_V   Lvaccsch                                                                                                                  VARCHAR2           2
ADHOC_EMPLOYMENT_V   Benbasal              Benefits base salary                                                                                NUMBER          11,2
ADHOC_EMPLOYMENT_V   Annbasrt              Annualized base salary                                                                              NUMBER          11,2
ADHOC_EMPLOYMENT_V   Orighrdt              This field preserves the original hire date of the employee in case of a break in employment and    DATE                                                                ISI_EDB_BAS      ORIGHRDT
                                           later reemployment. (Also called floor date.)
ADHOC_EMPLOYMENT_V   Hrdt401K                                                                                                                  DATE                 01/01/01 12:00 AM
ADHOC_EMPLOYMENT_V   Lstactn1              The most recent primary personnel action processed for the employee.                                VARCHAR2           2 01 - Initial employment                        ISI_EDB_BAS      LSTACTN1            01 - Initial employment             14 - Rehire                           40 - Multiple actions                       71 - Deleted record (display only)
                                                                                                                                                                    06 - Promotion                                                                      02 - Leave of absence with pay      21 - Additional appointment           41 - Extension of appointment               72 - Organization change (display only)
                                                                                                                                                                                                                                                        03 - Leave of absence without pay   22 - Revision of title                42 - Extension of additional compensation   73 - Employee ID change (display only)
                                                                                                                                                                                                                                                        04 - Return from leave of absence   23 - Additional compensation          43 - Extension of leave of absence
                                                                                                                                                                                                                                                        05 - Separation                     24 - Reappointment                    44 - Change of leave type
                                                                                                                                                                                                                                                        06 - Promotion                      25 - Change to account distribution   50 - Priority change
                                                                                                                                                                                                                                                        07 - Job reclassification           26 - Reinstatement
                                                                                                                                                                                                                                                        08 - Demotion                       27 - Salary change
                                                                                                                                                                                                                                                        10 - Transfer                       28 - Union increase
                                                                                                                                                                                                                                                        11 - Other change                   29 - In-grade increase
                                                                                                                                                                                                                                                        12 - Data correction                30 - Longevity increase

ADHOC_EMPLOYMENT_V   Lstactn2              The most recent secondary personnel action processed for the employee.                              VARCHAR2           2
ADHOC_EMPLOYMENT_V   Lstactn3              The most recent tertiary personnel action processed for the employee.                               VARCHAR2           2
ADHOC_EMPLOYMENT_V   Lstactdt              The effective date of the most recent personnel action.                                             DATE                                                                ISI_EDB_BAS      LSTACTDT
ADHOC_EMPLOYMENT_V   Prevdept                                                                                                                  VARCHAR2           8
ADHOC_EMPLOYMENT_V   Nxtprdte                                                                                                                  DATE
ADHOC_EMPLOYMENT_V   Prbstat               Not used.                                                                                           CHAR               2
ADHOC_EMPLOYMENT_V   Prbbgndt              Not used.                                                                                           DATE
ADHOC_EMPLOYMENT_V   Prbenddt              Not used.                                                                                           DATE
ADHOC_EMPLOYMENT_V   Prblact               Not used.                                                                                           CHAR               2
ADHOC_EMPLOYMENT_V   Prblacdt              Not used.                                                                                           DATE
ADHOC_EMPLOYMENT_V   Prcommnt              Not used.                                                                                           CHAR              30
ADHOC_EMPLOYMENT_V   Aastreet              Alternate address - street field 1                                                                  CHAR              30
ADHOC_EMPLOYMENT_V   Aastr2                Alternate address - street field 2                                                                  CHAR              30
ADHOC_EMPLOYMENT_V   Aacity                Alternate address - city                                                                            CHAR              30
ADHOC_EMPLOYMENT_V   Aacntry               Alternate address - country                                                                         CHAR               3
ADHOC_EMPLOYMENT_V   Nyu Aastr3            Alternate address - street field 3                                                                  CHAR              30
ADHOC_EMPLOYMENT_V   Nyu Province          Alternate address - province                                                                        CHAR              30
ADHOC_EMPLOYMENT_V   Nyu Postal Cd         Alternate address - postal code                                                                     CHAR              30
ADHOC_EMPLOYMENT_V   Nyu Phone No          Alternate address - phone number                                                                    CHAR              30
ADHOC_EMPLOYMENT_V   Nyu Comment1 Txt      Not used.                                                                                           CHAR              30
ADHOC_EMPLOYMENT_V   Nyu Comment2 Txt      Not used.                                                                                           CHAR              30
ADHOC_EMPLOYMENT_V   Wrk Hrs               The standard work hours for the employee in a normal work week. This number is used to              NUMBER           4,2 35                                             NYU_EDB_EMP      WRK_HRS
                                           determine the correct accrual rate for vacation and sick leave.
                                           4-digit numeric.
                                           Formatted 99.99.
                                           Valid values: 00.00 - 40.00.
ADHOC_EMPLOYMENT_V   Rfrl Sub Ctgy Cd      Job referral code identifying how the employee was referred to the University.                      VARCHAR2          2
ADHOC_EMPLOYMENT_V   Cr Of Nme Addr                                                                                                            VARCHAR2         30
ADHOC_EMPLOYMENT_V   Site Cd               The primary work location site of the employee.                                                     VARCHAR2          2
ADHOC_EMPLOYMENT_V   Chk Lctn Cd           Check location code                                                                                 VARCHAR2          2 01
ADHOC_EMPLOYMENT_V   Smstrs Int Srv No     The number of semesters of leave to be counted as interruption to years of service.                 INTEGER             0                                               NYU_EDB_EMP      SMSTRS_INT_SRV_NO
                                           2-digit numeric.
ADHOC_EMPLOYMENT_V   Rtrmnt Dt             The effective date of retirement of the employee. Maintained by Benefits only.                      DATE                   01/01/01 12:00 AM                            NYU_EDB_EMP      RTRMNT_DT
                                           10-character alphanumeric (maximum).
                                           Valid formats:
                                           MMDDCCYY
                                           MM DD CCYY
                                           MM/DD/CCYY
                                           MM-DD-CCYY
                                           MM.DD.CCYY
ADHOC_EMPLOYMENT_V   Instrctr Dt           The date when the employee achieved the rank of Instructor.                                         DATE                   01/01/01 12:00 AM                            NYU_EDB_EMP      INSTRCTR_DT
                                           Optional.
                                           5-character alphanumeric (maximum).
                                           Valid formats are:
                                           MMYY
                                           MM/YY




                                                                                                                                                                                                                                                                                                                                                                                                                Page 12 of 28
                                                                                                                                                                                             07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                   Field                                            Description                                               Data Type    Length Example                                             Source Table        Source Field                  Additional Info 1                              Additional Info 2            Additional Info 3                           Additional Info 4
ADHOC_EMPLOYMENT_V   Asstnt Dt            The date when the employee achieved the rank of Assistant Professor.                             DATE                 01/01/01 12:00 AM                                 NYU_EDB_EMP      ASSTNT_DT
                                          Optional.
                                          5-character alphanumeric (maximum).
                                          Valid formats are:
                                          MMYY
                                          MM/YY
ADHOC_EMPLOYMENT_V   Asscte Dt            The date when the employee achieved the rank of Associate Professor.                             DATE                    01/01/01 12:00 AM                              NYU_EDB_EMP      ASSCTE_DT
                                          Optional.
                                          5-character alphanumeric (maximum).
                                          Valid formats are:
                                          MMYY
                                          MM/YY
ADHOC_EMPLOYMENT_V   Prfssr Dt            The date when the employee achieved the rank of Professor.                                       DATE                    01/01/01 12:00 AM                              NYU_EDB_EMP      PRFSSR_DT
                                          Optional.
                                          5-character alphanumeric (maximum).
                                          Valid formats are:
                                          MMYY
                                          MM/YY
ADHOC_EMPLOYMENT_V   Vctn Due Hrs         The vacation hours due at time of separation.                                                    NUMBER            5,2 0                                                NYU_EDB_EMP      VCTN_DUE_HRS
                                          5-digit numeric.
                                          Valid format: 999.99.
ADHOC_EMPLOYMENT_V   Svrnc Due Pay Amt    The dollar amount due as severance pay at the time of separation.                                NUMBER            9,2 0                                                NYU_EDB_EMP      SVRNC_DUE_PAY_AMT
                                          9-digit numeric.
                                          Valid format: 9999999.99
ADHOC_EMPLOYMENT_V   Sub Actn Cd 1        The subaction code entered when the record of the employee was last updated.                     VARCHAR2            3                                                  NYU_EDB_EMP      SUB_ACTN_CD_1
ADHOC_EMPLOYMENT_V   Job 1 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 1 of the employee is   VARCHAR2            2
                                          paid.
ADHOC_EMPLOYMENT_V   Job 2 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 2 of the employee is   VARCHAR2            2
                                          paid.
ADHOC_EMPLOYMENT_V   Job 3 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 3 of the employee is   VARCHAR2            2
                                          paid.
ADHOC_EMPLOYMENT_V   Job 4 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 4 of the employee is   VARCHAR2            2
                                          paid.
ADHOC_EMPLOYMENT_V   Job 5 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 5 of the employee is   VARCHAR2            2
                                          paid.
ADHOC_EMPLOYMENT_V   Job 6 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 6 of the employee is   VARCHAR2            2
                                          paid.
ADHOC_EMPLOYMENT_V   Job 7 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 7 of the employee is   VARCHAR2            2
                                          paid.
ADHOC_EMPLOYMENT_V   Tx Treaty Frm Id                                                                                                         VARCHAR2         1
ADHOC_EMPLOYMENT_V   Tx Treaty Lmt Amt    Indicates the tax treaty compensation limit (for non-resident aliens).                              NUMBER         7,2
ADHOC_EMPLOYMENT_V   Tx Treaty Lmt Dt     Indicates the expiration date of the tax treaty compensation limitation of the employee.            DATE
ADHOC_EMPLOYMENT_V   Email Addr           Identifies the university email address (if activated) of the employee.                             VARCHAR2       30
ADHOC_EMPLOYMENT_V   Fax Phone No         Indicates the primary office fax number of the employee.                                            VARCHAR2       10
ADHOC_EMPLOYMENT_V   Netid                Idientifies the university NetId of the employee.                                                   VARCHAR2       16
ADHOC_EMPLOYMENT_V   Racfid               Not used.                                                                                           VARCHAR2        8
ADHOC_EMPLOYMENT_V   Pin                  Not used.                                                                                           VARCHAR2        8
ADHOC_EMPLOYMENT_V   Service Award No     Indicates the service year milestone the employee has achieved.                                     DATE
ADHOC_EMPLOYMENT_V   Oath Ind             Identifies whether an instructional faculty member has signed and filed the NY State teaching oath. VARCHAR2         1

ADHOC_EMPLOYMENT_V   Emeritus Dt          Identifies the effective date of status as Professor Emeritus of a faculty member.               DATE
ADHOC_EMPLOYMENT_V   Prvsrv For Tnr Ind   Indicates whether previous service has been a consideration in tenure decisions.                 VARCHAR2            1 Y - Qualifying service                           NYU_EDB_EMP      PRVSRV_FOR_TNR_IND
                                          1-position alpha.
                                          Values: N - No qualifying service
                                          Y - Qualifying service
                                          V - Qualifying service not confirmed (verify)
ADHOC_EMPLOYMENT_V   Payrate              Identifies the job rate of pay per pay cycle of the employee.                                    NUMBER           11,4 2,500.00
ADHOC_EMPLOYMENT_V   Ratecode             Indicates if PAY RATE is hourly or payment for the pay period.                                   VARCHAR2            1 P - Salary for pay period                        ISI_EDB_JOB      RATECODE
                                          1-character alphanumeric.
                                          Valid codes:
                                          H - Hourly rate
                                          P - Salary for pay period
ADHOC_EMPLOYMENT_V   Reteffdt             The effective date of the new rate.                                                              DATE                                                                   ISI_EDB_PAY      RETEFFDT
                                          10-character alphanumeric (maximum).
                                          Valid formats:
                                          MMDDCCYY
                                          MM DD CCYY
                                          MM/DD/CCYY
                                          MM-DD-CCYY
                                          MM.DD.CCYY
ADHOC_EMPLOYMENT_V   Pctfull                                                                                                               NUMBER            5,2 100
ADHOC_EMPLOYMENT_V   Payterm              Identifies the length of the job assignment and the period of payment.                           VARCHAR2              02 - 10-month assignment paid over 12 months     ISI_EDB_JOB      PAYTERM              00 - 10-month assignment paid over 10 months    90 - 9-month assignment paid over 10                          97 - 4 1/2 month assignment paid over 7 months (spring)
                                                                                                                                                                                                                                                        01-09 - specific number of payments for temp.   months                                                        98 - 9-month assignment paid over 8 months
                                                                                                                                                                                                                                                        appt.                                           92 - 9-month assignment paid over 12
                                                                                                                                                                                                                                                        02 - 10-month assignment paid over 12 months    months
                                                                                                                                                                                                                                                        12 - 11-month assignment paid over 12 months    94 - 4 1/2 month assignment paid over 4
                                                                                                                                                                                                                                                        22 - 12-month assignment paid over 12 months    months (fall, spring)
                                                                                                                                                                                                                                                                                                        96 - 4 1/2 month assignment paid over 6
                                                                                                                                                                                                                                                                                                        months (fall)



ADHOC_EMPLOYMENT_V   Paycycle             Identifies the frequency of payment for the job assignment.                                      VARCHAR2                B1, B2 - Biweekly                              ISI_EDB_JOB      PAYCYCLE                                                                                                                           B1, B2 - Biweekly
                                                                                                                                                                   M1, M2 - Monthly                                                                                                                                                                                   M1, M2 - Monthly
                                                                                                                                                                   W1, W2 - Weekly                                                                                                                                                                                    W1, W2 - Weekly




                                                                                                                                                                                                                                                                                                                                                                                                       Page 13 of 28
                                                                                                                                                                                                  07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View                   Field                                              Description                                                    Data Type   Length Example                                            Source Table        Source Field   Additional Info 1   Additional Info 2   Additional Info 3                               Additional Info 4
ADHOC_EMPLOYMENT_V   Timecode            The method of time reporting required for this job assignment, and whether this job is listed on         VARCHAR2            P - Positive; listed                                                                                                                              Hourly employees:
                                         Time Reports.                                                                                                                E - Exception; not listed                                                                                                                         N - Positive; not listed
                                                                                                                                                                                                                                                                                                                        P - Positive; listed
                                                                                                                                                                                                                                                                                                                        Salaried employees:
                                                                                                                                                                                                                                                                                                                        E - Exception; not listed
                                                                                                                                                                                                                                                                                                                        L - Exception by salary; listed
                                                                                                                                                                                                                                                                                                                        T - Exception by time; listed
                                                                                                                                                                                                                                                                                                                        Any employee:
                                                                                                                                                                                                                                                                                                                        W - Job without salary; not listed

ADHOC_EMPLOYMENT_V   Req To Rcrt         Request to Recruit number.                                                                               CHAR               6
ADHOC_EMPLOYMENT_V   Job Eval No         Job evaluation code.                                                                                     CHAR               9
ADHOC_EMPLOYMENT_V   Job Descr Txt       Job description code.                                                                                    CHAR              14
ADHOC_EMPLOYMENT_V   Crse Ttl            Identifies the course section number taught by the instructor for this job (not required).               CHAR              30
ADHOC_EMPLOYMENT_V   Cntct Hrs           Identifies the contact hours associated with the course taught by the instructor for this jo (not        NUMBER           6,2
                                         required).
ADHOC_EMPLOYMENT_V   Cntct Typ Cd        A code available for school use to further identify the affiliation with a course (not required) of an   CHAR               1
                                         instructor.
ADHOC_EMPLOYMENT_V   Job Bse Sal Amt                                                                                                              NUMBER           9,2
ADHOC_EMPLOYMENT_V   Job Rate Cd         The rate code associated with this job assignment identifying if this is a salaried or hourly job.       CHAR               1

ADHOC_EMPLOYMENT_V   Job Stamp           A unique timestamp per job in the database.                                                              VARCHAR2          26
ADHOC_EMPLOYMENT_V   Job Acct Tot Amt    The total amount to be paid for all account for the specified job per pay cycle.                         NUMBER           9,3 2,500.00
ADHOC_EMPLOYMENT_V   Longevity Cd        A code identifying the longevity tier achieved (for bargaining unit eligible jobs).                      CHAR              10
ADHOC_EMPLOYMENT_V   Hrsbal01                                                                                                                     NUMBER           9,2
ADHOC_EMPLOYMENT_V   Hrsbal02                                                                                                                     NUMBER           9,2
ADHOC_EMPLOYMENT_V   Hispanic Ind        A Y/N flag identify whether the employee has identified themselves to be of hispanic origin.             CHAR               1

ADHOC_EMPLOYMENT_V   Race1 Ind           A code identifying the identified ethnicity of the employee.                                             CHAR               1
ADHOC_EMPLOYMENT_V   Race2 Ind           See RACE1_IND (employee may identify multiple ethnicities).                                              CHAR               1
ADHOC_EMPLOYMENT_V   Race3 Ind           See RACE1_IND (employee may identify multiple ethnicities).                                              CHAR               1
ADHOC_EMPLOYMENT_V   Race4 Ind           See RACE1_IND (employee may identify multiple ethnicities).                                              CHAR               1
ADHOC_EMPLOYMENT_V   Race5 Ind           See RACE1_IND (employee may identify multiple ethnicities).                                              CHAR               1
ADHOC_EMPLOYMENT_V   Race6 Ind           Not used.                                                                                                CHAR               1
ADHOC_EMPLOYMENT_V   Race7 Ind           Not used.                                                                                                CHAR               1
ADHOC_EMPLOYMENT_V   Race8 Ind           Not used.                                                                                                CHAR               1
ADHOC_EMPLOYMENT_V   Race9 Ind           Not used.                                                                                                CHAR               1
ADHOC_EMPLOYMENT_V   Race10 Ind          Not used.                                                                                                CHAR               1
ADHOC_EMPLOYMENT_V   Mobile Device No    Cell phone number for employee                                                                           VARCHAR2          10
ADHOC_EMPLOYMENT_V   Statusdt            The effective date of the Employment Status (see Emplstat) of an employee.                               DATE
ADHOC_EMPLOYMENT_V   Lstpypdt            Last pay date the employee was paid (from any job).                                                      DATE                 09/30/08 12:00 AM
ADHOC_EMPLOYMENT_V   Hrsbal45                                                                                                                     NUMBER           9,2
ADHOC_EMPLOYMENT_V   Bldng Nm            Work Location of Employee -Building Name                                                                 CHAR              30
ADHOC_EMPLOYMENT_V   Bldng Addr          Work Location of Employee - Address                                                                      CHAR              30
ADHOC_EMPLOYMENT_V   Bldng Cty           Work Location of Employee - City                                                                         CHAR              30
ADHOC_EMPLOYMENT_V   Bldng St            Work Location of Employee - State                                                                        CHAR               2
ADHOC_EMPLOYMENT_V   Bldng Zp            Work Location of Employee - Postal Code                                                                  CHAR              10
ADHOC_EMPLOYMENT_V   Unit Name           Hierarchy is Unit -> Dvision -> Department                                                               VARCHAR2          30 DIVISION OF LIBRARIES
ADHOC_EMPLOYMENT_V   Div Name            Hierarchy is Unit -> Division -> Department                                                              VARCHAR2          30 DIVISION OF LIBRARIES
ADHOC_EMPLOYMENT_V   Hr Rep Name         The name of the HR Officer (primary job) of an employee.                                                 VARCHAR2          30
ADHOC_EMPLOYMENT_V   Hr Rep Netid        The university NetID of the HR Officer (primary job) of the employee.                                    VARCHAR2          16
ADHOC_EMPLOYMENT_V   Vol Invol Ind       Voluntary/Involuntary separation indicator.                                                              CHAR               1
ADHOC_EMPLOYMENT_V   Ui Challenge Ind    Unemployment Insurance challenge indicator.                                                              CHAR               1
HEADCOUNTS_V         Emplid              Social Security Number of employee                                                                       INTEGER              111223333
HEADCOUNTS_V         Nyuid               University ID - System generated employee identification number used to uniquely identify                VARCHAR2          11 N12345678
                                         employees and is not the same as the employee social security number.
HEADCOUNTS_V         Emplname            Name of employee.                                                                                        VARCHAR2          30                                                 ISI_EDB_BAS      EMPLNAME
                                         Valid format: Last name, comma, first name, space, middle initial
HEADCOUNTS_V         Job Ttl 1           The job assignment title for this job assignment.                                                        CHAR              30 DEVELOPMENT COMMUNICATIONS MAN                  NYU_EDB_JOB      JOB_TTL_1
                                         60-character alphanumeric (stored as two 30-position fields).
HEADCOUNTS_V         Job Ttl 2           The job assignment title for this job assignment.                                                        CHAR              30 AGER                                            NYU_EDB_JOB      JOB_TTL_2
                                         60-character alphanumeric (stored as two 30-position fields).
HEADCOUNTS_V         Jobdept             Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be             VARCHAR2           8 43020                                           ISI_EDB_JOB      JOBDEPT
                                         from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                         Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
HEADCOUNTS_V         Dept Name           The code of the department responsible for this job assignment.                                          VARCHAR2          30 RESEARCH DEVELOPMENT                            ISI_EDB_JOB      JOBDEPT
                                         5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                         Use the table look-up feature to find current values and translations.
HEADCOUNTS_V         Homedept            Primary (home) department of an employee (department of the primary appointment). Jobdept is VARCHAR2                       8 56210                                           ISI_EDB_BAS      HOMEDEPT
                                         the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                         Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

HEADCOUNTS_V         Jobno               JobNo is the physical number of the job in the database; Prty_Cd is the priority of the job. JobNo       DATE                   1                                             ISI_EDB_JOB,     JOBNO
                                         gets reset nightly to the Prty_Cd. Use Prty_Cd instead of JobNo. An employee can have up to 7                                                                                 ISI_EDB_ACC,
                                         jobs. Job #7 is for Payroll use only.                                                                                                                                         NYU_EDB_JOB,
                                                                                                                                                                                                                       NYU_EDB_ACT
HEADCOUNTS_V         Prty Cd             Priority code of 1 should be assigned to the primary job assignment. An employee can have up to INTEGER                         1                                             NYU_EDB_JOB      PRTY_CD
                                         7 jobs and must have one appointment with priority 1. No two appointments may have the same
                                         priority. Job priority 7 is for Payroll use only.
HEADCOUNTS_V         Emplmtdt            Employment date. Generally this date is updated when an employee moves into/out of a benefits- DATE                             09/01/05 12:00 AM
                                         eligible assignment.




                                                                                                                                                                                                                                                                                                                                                            Page 14 of 28
                                                                                                                                                                                     07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View               Field                                               Description                                             Data Type   Length Example                                         Source Table       Source Field                    Additional Info 1                               Additional Info 2                                Additional Info 3                                            Additional Info 4
HEADCOUNTS_V     Rtrmnt Dt           The effective date of retirement of the employee. Maintained by Benefits only.                     DATE                01/01/01 12:00 AM                             NYU_EDB_EMP      RTRMNT_DT
                                     10-character alphanumeric (maximum).
                                     Valid formats:
                                     MMDDCCYY
                                     MM DD CCYY
                                     MM/DD/CCYY
                                     MM-DD-CCYY
                                     MM.DD.CCYY
HEADCOUNTS_V     Object Cd           Identifies the general type of work performed and the full-time/part-time status for the PRIMARY   INTEGER             100 - Admin/professional (FT)                 NYU_EDB_EMP_T OBJECT_CD                                                                                                                JOB_OBJECT_CD (OBJECT_CD on                        100 - Admin/professional (FT)
                                     (job #1) assignment of the employee.                                                                                   102 - Faculty (FT)                                                                 110 - Admin/professional (PT)                                                                     NYU_EDB_JOB_T) is the object code of the           101 - Teaching or graduate assistant (FT)
                                                                                                                                                                                                                                               111 - Grader, tutor, lab assistant (PT)           118 - Student (workstudy)                       particular job. Use the Object Code from the       102 - Faculty (FT)
                                                                                                                                                                                                                                               112 - Faculty (PT)                                119 - Student (non-workstudy)                   Emp_T table if you are looking at primary          103 - Professional researcher (FT)
                                                                                                                                                                                                                                               113 - Professional researcher (PT)                130 - Research assistant (FT)                   jobs, use the object code from the Job_T           104 - Laboratory/technical staff (FT)
                                                                                                                                                                                                                                               114 - Laboratory/technical staff (PT)             131 - Research assistant (FT)                   table if you are looking at the object codes of    106 - Office/clerical staff (FT)
                                                                                                                                                                                                                                               115 - Casual employee (PT)                        542 - Post-doctoral fellow (FT)                 all jobs.                                          107 - Service staff (FT)
                                                                                                                                                                                                                                               116 - Office/clerical staff (PT)
                                                                                                                                                                                                                                               117 - Service staff (PT)

HEADCOUNTS_V     Job Object Cd       JOB_OBJECT_CD, which is listed as field OBJECT_CD on the NYU_EDB_JOB_T table is the                INTEGER             100 - Admin/professional (FT)                 NYU_EDB_JOB_T    OBJECT_CD           OBJECT_CD, which is listed as field               Use the Object Code from the Emp_T table if
                                     object code of the particular job- each job has one.                                                                   102 - Faculty (FT)                                                                 OBJECT_CD on the NYU_EDB_EMP_T table,             you are only looking at primary jobs, use the
                                                                                                                                                                                                                                               is the object code of the primary job and is      object code from the Job_T table if you are
                                                                                                                                                                                                                                               defaulted from the Object Code of Job #1.         looking at the object codes of all jobs.

HEADCOUNTS_V     Range               A numeric salary ranking assigned to most administrative, technical and clerical assignments;      VARCHAR2          2 OC 104, 114 -> Grade Blank; 40 - 45           ISI_EDB_JOB      RANGE                                                                 OC 101, 111, 102, 112, 103, 113, 115, 118,
                                     known as the grade of the job.                                                                                                                                                                                                                              119, 107, 117, 130, 131, 542 -> Grade Blank
                                                                                                                                                                                                                                                                                                 OC 100, 110 -> Grade Blank; 11 - 21
                                                                                                                                                                                                                                                                                                 OC 104, 114 -> Grade Blank; 40 - 45
                                                                                                                                                                                                                                                                                                 OC 106, 116 -> Grade Blank; 1, 2, 3, 5 - 10



HEADCOUNTS_V     Emplstat            Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either       VARCHAR2          1 A
                                     = A,L, P or EMPLSTAT <> T for query/reporting limits.
HEADCOUNTS_V     Regtemp             Indicates whether the primary job assignment of the employee is regular or temporary.              VARCHAR2          1 R - Regular                                   ISI_EDB_BAS      REGTEMP
                                     Valid codes:
                                     R - Regular
                                     T - Temporary
HEADCOUNTS_V     Aptbegdt            The date this job assignment or appointment is effective.                                          DATE                09/01/05 12:00 AM                             ISI_EDB_JOB      APTBEGDT                                                              To set the limit to get active appointments                                                        Valid formats:
                                     The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                         only                                                                                               MMDDYYYY
                                                                                                                                                                                                                                                                                                   - Use APTBEGDT < sysdate and                                                                     MM DD YYYY
                                                                                                                                                                                                                                                                                                 APTENDDT > sysdate                                                                                 MM/DD/YYYY
                                                                                                                                                                                                                                                                                                 To identify cancelled appointments:                                                                MM-DD-YYYY
                                                                                                                                                                                                                                                                                                   - APTBEGDT = APTENDDT and                                                                        MM.DD.YYYY
                                                                                                                                                                                                                                                                                                 APPT_AMT = 1
HEADCOUNTS_V     Aptenddt            The date this job assignment or appointment ends.                                                  DATE                12/31/99 12:00 AM                             ISI_EDB_JOB      APTENDDT                                                              To set the limit to get active appointments                                                        Valid formats:
                                     The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                         only                                                                                               MMDDYYYY
                                                                                                                                                                                                                                                                                                   - Use APTBEGDT < sysdate and                                                                     MM DD YYYY
                                                                                                                                                                                                                                                                                                 APTENDDT > sysdate                                                                                 MM/DD/YYYY
                                                                                                                                                                                                                                                                                                 To identify cancelled appointments:                                                                MM-DD-YYYY
                                                                                                                                                                                                                                                                                                   - APTBEGDT = APTENDDT and                                                                        MM.DD.YYYY
                                                                                                                                                                                                                                                                                                 APPT_AMT = 1
HEADCOUNTS_V     Jobclass            The job classification code assigned to this job assignment.                                       VARCHAR2          6 220163                                        ISI_EDB_JOB      JOBCLASS
                                     Can be decoded using HR.ISI_CDB_JOB_T table.
                                     6-character alphanumeric.
                                     Use the table look-up feature to find current values and translations.
HEADCOUNTS_V     Jobtitle            The job assignment title for this job assignment.                                                    VARCHAR2       60 DEVELOPMENT COMMUNICATIONS MANAGER            NYU_EDB_JOB      JOB_TTL_1,
                                     60-character alphanumeric (concatenated in this view, but stored as two 30-position fields Job Ttl 1                                                                                  JOB_TTL_2
                                     and Job Ttl 2 in the source table).
HEADCOUNTS_V     Job Fmly Cd         This code identifies the general functional responsibility of this job assignment.                 CHAR              1 A - Administrative services                   NYU_EDB_JOB      JOB_FMLY_CD         1 - Finance                                       A - Administrative services                     G - General administrative support                 Q - Admissions, registration, and financial aid
                                                                                                                                                                                                                                               2 - Communications                                B - Sergeant guards (for object code 107,       K - Communications                                 S - Survivors of retirees
                                                                                                                                                                                                                                               3 - Institutional facilities                      117)                                            L - Library, technical, and data processing (for   T - Animal, dental/medical, media lab technicians
                                                                                                                                                                                                                                               4 - Administrative services                       C - Elevator starters (for object code 107,     object code 100, 110)                              X - Academic administrators not in plan
                                                                                                                                                                                                                                               5 - Student affairs                               117)                                            L - Comp, equip fab, general technical             Z - Student affairs
                                                                                                                                                                                                                                               6 - Admissions, registration, and financial aid   D - Academic support (for object code 100,      support (for object code 104, 114)
                                                                                                                                                                                                                                               7 - Library, technical, and data processing       110)                                            N - Institutional facilities
                                                                                                                                                                                                                                               8 - Academic support                              D - Cdl, dental equipment repair technicians
                                                                                                                                                                                                                                                                                                 (for object code 104, 114)
                                                                                                                                                                                                                                                                                                 F - Finance

HEADCOUNTS_V     Job Emp Ctgy Cd     The employee category associated with this job assignment which identifies a grouping of similar   VARCHAR2          1 F - Faculty                                   NYU_EDB_JOB      EMP_CTGY_CD         A - Administrative and Professional               N - Student
                                     jobs for reporting purposes.                                                                                                                                                                              D - Post-Doctoral Fellows                         R - Professional Researcher
                                                                                                                                                                                                                                               F - Faculty                                       S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                               G - Unpaid appointments                           T - Casual employees
                                                                                                                                                                                                                                               K - Graduate, Research, and Teaching              X - University Officers
                                                                                                                                                                                                                                               Assistants                                        Z - Retired employees
                                                                                                                                                                                                                                               M - Management, Directors and Academic
                                                                                                                                                                                                                                               Administrators
HEADCOUNTS_V     Emp Ctgy Cd         The employee category associated with this job assignment which identifies a grouping of similar   VARCHAR2          1 F - Faculty                                   NYU_EDB_JOB      EMP_CTGY_CD         A - Administrative and Professional               N - Student
                                     jobs for reporting purposes.                                                                                                                                                                              D - Post-Doctoral Fellows                         R - Professional Researcher
                                                                                                                                                                                                                                               F - Faculty                                       S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                               G - Unpaid appointments                           T - Casual employees
                                                                                                                                                                                                                                               K - Graduate, Research, and Teaching              X - University Officers
                                                                                                                                                                                                                                               Assistants                                        Z - Retired employees
                                                                                                                                                                                                                                               M - Management, Directors and Academic
                                                                                                                                                                                                                                               Administrators
HEADCOUNTS_V     Orgid               Active employees are stored in the Active Org which is OrgID=blank; Retirees are in the RET org VARCHAR2            13 <blank> or <RET>
                                     with OrgID=RET.
HEADCOUNTS_V     Qtrno               Quarter Number - The field qtrno should be =0 in most queries but in the actual table in HRIS it can                   0
                                     also be a 4 (for tax purposes).
HEADCOUNTS_V     Lstpypdt            Last pay date the employee was paid (from any job).                                                  DATE              09/30/08 12:00 AM



                                                                                                                                                                                                                                                                                                                                                                                                                                      Page 15 of 28
                                                                                                                                                                                     07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View               Field                                                 Description                                           Data Type   Length Example                                         Source Table         Source Field                   Additional Info 1                               Additional Info 2                                Additional Info 3                                            Additional Info 4
HEADCOUNTS_V     Unit Name           Hierarchy is Unit -> Dvision -> Department                                                         VARCHAR2         30 DIVISION OF LIBRARIES
HEADCOUNTS_V     Div Name            Hierarchy is Unit -> Division -> Department                                                        VARCHAR2         30 DIVISION OF LIBRARIES
HEADCOUNTS_V     Hr Rep Name         The name of the HR Officer (primary job) of an employee.                                           VARCHAR2         30
HEADCOUNTS_V     Hr Rep Netid        The university NetID of the HR Officer (primary job) of the employee.                              VARCHAR2         16
HEADCOUNTS_V     Birthdt             Date of birth of the employee.                                                                     DATE                  03/15/80 12:00 AM                           ISI_EDB_PER      BIRTHDT
                                     Required.
                                     10-character alphanumeric (maximum).
                                     Valid formats:
                                     MMDDYYYY
                                     MM DD YYYY
                                     MM/DD/YYYY
                                     MM-DD-YYYY
                                     MM.DD.YYYY

HEADCOUNTS_V     Sex                 Th sex of the employee.                                                                            CHAR              1 M                                             ISI_EDB_PER      SEX
                                     Valid codes:
                                     F - Female
                                     M - Male
HEADCOUNTS_V     Ethnicty            No longer used (see ETHNICITY_RACE).                                                               CHAR              1 A - Native American/Amerind/Alaskan native    ISI_EDB_PER      ETHNICTY                                                               If the CNTRY code of the Organization Table                                                        Blank - Not indicated
                                                                                                                                                                                                                                                                                                  entry for this ORG is CAN, the ETHNICITY                                                           A - Native American/Amerind/Alaskan native
                                                                                                                                                                                                                                                                                                  must be 1, 2, 3, 4, or blank. Otherwise, it                                                        B - Black/African-American
                                                                                                                                                                                                                                                                                                  must be A, B, C, R, S, or blank.                                                                   C - Caucasian/White
                                                                                                                                                                                                                                                                                                                                                                                                     R - Asian/Pacific islander
                                                                                                                                                                                                                                                                                                                                                                                                     S - Hispanic/Latino
PASS_ACTIONS_V   Action Code         Action code number                                                                                 VARCHAR2          2 25                                            REQ_HDR_NYU_T ACTION_CODE
PASS_ACTIONS_V   Job Ttl 1           The job assignment title for this job assignment.                                                  CHAR             30 DEVELOPMENT COMMUNICATIONS MAN                NYU_EDB_JOB   JOB_TTL_1
                                     60-character alphanumeric (stored as two 30-position fields).
PASS_ACTIONS_V   Sub Action Code     Subaction code number                                                                              VARCHAR2          3 O30                                           REQ_HDR_NYU_T SUB_ACTION_CODE
PASS_ACTIONS_V   Descr               The general descriptive cateory for the PASS action.                                               VARCHAR2         50 Account Change
PASS_ACTIONS_V   Descr2              The specific descriptive category for the PASS action.                                             VARCHAR2         50 Account Change
PASS_ACTIONS_V   Effective Date      Effective date of transaction                                                                                          09/01/06 12:00 AM                             REQ_HDR_NYU_T EFFECTIVE_DATE
PASS_ACTIONS_V   Object Cd           Identifies the general type of work performed and the full-time/part-time status for the PRIMARY   INTEGER             100 - Admin/professional (FT)                 NYU_EDB_EMP_T OBJECT_CD                                                                                                                 JOB_OBJECT_CD (OBJECT_CD on                        100 - Admin/professional (FT)
                                     (job #1) assignment of the employee.                                                                                   102 - Faculty (FT)                                                                  110 - Admin/professional (PT)                                                                     NYU_EDB_JOB_T) is the object code of the           101 - Teaching or graduate assistant (FT)
                                                                                                                                                                                                                                                111 - Grader, tutor, lab assistant (PT)           118 - Student (workstudy)                       particular job. Use the Object Code from the       102 - Faculty (FT)
                                                                                                                                                                                                                                                112 - Faculty (PT)                                119 - Student (non-workstudy)                   Emp_T table if you are looking at primary          103 - Professional researcher (FT)
                                                                                                                                                                                                                                                113 - Professional researcher (PT)                130 - Research assistant (FT)                   jobs, use the object code from the Job_T           104 - Laboratory/technical staff (FT)
                                                                                                                                                                                                                                                114 - Laboratory/technical staff (PT)             131 - Research assistant (FT)                   table if you are looking at the object codes of    106 - Office/clerical staff (FT)
                                                                                                                                                                                                                                                115 - Casual employee (PT)                        542 - Post-doctoral fellow (FT)                 all jobs.                                          107 - Service staff (FT)
                                                                                                                                                                                                                                                116 - Office/clerical staff (PT)
                                                                                                                                                                                                                                                117 - Service staff (PT)

PASS_ACTIONS_V   Emplname            Name of employee.                                                                            VARCHAR2               30                                               ISI_EDB_BAS      EMPLNAME
                                     Valid format: Last name, comma, first name, space, middle initial
PASS_ACTIONS_V   Nyuid               University ID - System generated employee identification number used to uniquely identify    VARCHAR2               11 N12345678
                                     employees and is not the same as the employee social security number.
PASS_ACTIONS_V   Homedept            Primary (home) department of an employee (department of the primary appointment). Jobdept is VARCHAR2                8 56210                                         ISI_EDB_BAS      HOMEDEPT
                                     the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                     Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

PASS_ACTIONS_V   Jobclass            The job classification code assigned to this job assignment.                                       VARCHAR2          6 220163                                        ISI_EDB_JOB      JOBCLASS
                                     Can be decoded using HR.ISI_CDB_JOB_T table.
                                     6-character alphanumeric.
                                     Use the table look-up feature to find current values and translations.
PASS_ACTIONS_V   Lstpypdt            Last pay date the employee was paid (from any job).                                             DATE                     09/30/08 12:00 AM
PASS_ACTIONS_V   Prty Cd             Priority code of 1 should be assigned to the primary job assignment. An employee can have up to INTEGER                  1                                           NYU_EDB_JOB      PRTY_CD
                                     7 jobs and must have one appointment with priority 1. No two appointments may have the same
                                     priority. Job priority 7 is for Payroll use only.
PASS_ACTIONS_V   Emplstat            Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either       VARCHAR2          1 A
                                     = A,L, P or EMPLSTAT <> T for query/reporting limits.
PASS_ACTIONS_V   Dept Name           The code of the department responsible for this job assignment.                                    VARCHAR2         30 RESEARCH DEVELOPMENT                          ISI_EDB_JOB      JOBDEPT
                                     5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                     Use the table look-up feature to find current values and translations.
PASS_ACTIONS_V   Div Name            Hierarchy is Unit -> Division -> Department                                                        VARCHAR2         30 DIVISION OF LIBRARIES
PASS_ACTIONS_V   Unit Name           Hierarchy is Unit -> Dvision -> Department                                                         VARCHAR2         30 DIVISION OF LIBRARIES
PASS_ACTIONS_V   Job Object Cd       JOB_OBJECT_CD, which is listed as field OBJECT_CD on the NYU_EDB_JOB_T table is the                INTEGER             100 - Admin/professional (FT)                 NYU_EDB_JOB_T    OBJECT_CD            OBJECT_CD, which is listed as field               Use the Object Code from the Emp_T table if
                                     object code of the particular job- each job has one.                                                                   102 - Faculty (FT)                                                                  OBJECT_CD on the NYU_EDB_EMP_T table,             you are only looking at primary jobs, use the
                                                                                                                                                                                                                                                is the object code of the primary job and is      object code from the Job_T table if you are
                                                                                                                                                                                                                                                defaulted from the Object Code of Job #1.         looking at the object codes of all jobs.

PASS_ACTIONS_V   Regtemp             Indicates whether the primary job assignment of the employee is regular or temporary.              VARCHAR2          1 R - Regular                                   ISI_EDB_BAS      REGTEMP
                                     Valid codes:
                                     R - Regular
                                     T - Temporary
PASS_ACTIONS_V   Job Fmly Cd         This code identifies the general functional responsibility of this job assignment.                 CHAR              1 A - Administrative services                   NYU_EDB_JOB      JOB_FMLY_CD          1 - Finance                                       A - Administrative services                     G - General administrative support                 Q - Admissions, registration, and financial aid
                                                                                                                                                                                                                                                2 - Communications                                B - Sergeant guards (for object code 107,       K - Communications                                 S - Survivors of retirees
                                                                                                                                                                                                                                                3 - Institutional facilities                      117)                                            L - Library, technical, and data processing (for   T - Animal, dental/medical, media lab technicians
                                                                                                                                                                                                                                                4 - Administrative services                       C - Elevator starters (for object code 107,     object code 100, 110)                              X - Academic administrators not in plan
                                                                                                                                                                                                                                                5 - Student affairs                               117)                                            L - Comp, equip fab, general technical             Z - Student affairs
                                                                                                                                                                                                                                                6 - Admissions, registration, and financial aid   D - Academic support (for object code 100,      support (for object code 104, 114)
                                                                                                                                                                                                                                                7 - Library, technical, and data processing       110)                                            N - Institutional facilities
                                                                                                                                                                                                                                                8 - Academic support                              D - Cdl, dental equipment repair technicians
                                                                                                                                                                                                                                                                                                  (for object code 104, 114)
                                                                                                                                                                                                                                                                                                  F - Finance




                                                                                                                                                                                                                                                                                                                                                                                                                                       Page 16 of 28
                                                                                                                                                                                                  07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


           View               Field                                                Description                                                       Data Type   Length Example                                          Source Table        Source Field                   Additional Info 1                                 Additional Info 2                             Additional Info 3                                            Additional Info 4
PASS_ACTIONS_V      Emp Ctgy Cd          The employee category associated with this job assignment which identifies a grouping of similar           VARCHAR2           1 F - Faculty                                   NYU_EDB_JOB      EMP_CTGY_CD         A - Administrative and Professional               N - Student
                                         jobs for reporting purposes.                                                                                                                                                                                       D - Post-Doctoral Fellows                         R - Professional Researcher
                                                                                                                                                                                                                                                            F - Faculty                                       S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                                            G - Unpaid appointments                           T - Casual employees
                                                                                                                                                                                                                                                            K - Graduate, Research, and Teaching              X - University Officers
                                                                                                                                                                                                                                                            Assistants                                        Z - Retired employees
                                                                                                                                                                                                                                                            M - Management, Directors and Academic
                                                                                                                                                                                                                                                            Administrators
PASS_ACTIONS_V      Transid              PASS Transaction ID number                                                                                 VARCHAR2          10 72199                                         REQ_HDR_NYU_T TRANSID
PASS_ACTIONS_V      True Officer Flag    Indicator signifying whether the position of the employee is identified as an officer of the university.   VARCHAR2          12

PASS_ACTIONS_V      Addl Data Value      Identifies a subcategory selected for the PASS action type (eg. Return from Leave, Leave with Pay VARCHAR2                2000
                                         or Leave without Pay for a Leave of Absence request).
PASS_ACTIONS_V      Today Date           The run date of the query/report being generated.                                                                               10/13/08
PASS_ACTIONS_V      Jobtitle             The job assignment title for this job assignment.                                                    VARCHAR2                60 DEVELOPMENT COMMUNICATIONS MANAGER            NYU_EDB_JOB      JOB_TTL_1,
                                         60-character alphanumeric (concatenated in this view, but stored as two 30-position fields Job Ttl 1                                                                                           JOB_TTL_2
                                         and Job Ttl 2 in the source table).
PASS_ACTIONS_V      Cancelled Appt Ind   Cancelled appointments                                                                                     VARCHAR2          13 Real Apt
PASS_ACTIONS_V      Page Name            PASS page name                                                                                             VARCHAR2          30 Account Changes                               REQ_HDR_NYU_T PAGE_NAME
PASS_ACTIONS_V      Job Ttl 2            The job assignment title for this job assignment.                                                          CHAR              30 AGER                                          NYU_EDB_JOB   JOB_TTL_2
                                         60-character alphanumeric (stored as two 30-position fields).
PASS_ACTIONS_V      Reqd Object Cd       Object Code of employee                                                                                    VARCHAR2           3 100 - Admin/professional (FT)                 REQ_HDR_NYU_T REQD_OBJECT_CD
                                                                                                                                                                         102 - Faculty (FT)
PASS_HIRES_TRFS_V   Nyuid                University ID - System generated employee identification number used to uniquely identify                  VARCHAR2          11 N12345678
                                         employees and is not the same as the employee social security number.
PASS_HIRES_TRFS_V   REQ_TYPE             Identifies the PASS transaction record as either containing [R]equest or [H]istorical information.         VARCHAR2           1

PASS_HIRES_TRFS_V   Emplname             Name of employee.                                                                                          VARCHAR2          30                                               ISI_EDB_BAS      EMPLNAME
                                         Valid format: Last name, comma, first name, space, middle initial
PASS_HIRES_TRFS_V   Emplstat             Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either               VARCHAR2           1 A
                                         = A,L, P or EMPLSTAT <> T for query/reporting limits.
PASS_HIRES_TRFS_V   Regtemp              Indicates whether the primary job assignment of the employee is regular or temporary.                      VARCHAR2           1 R - Regular                                   ISI_EDB_BAS      REGTEMP
                                         Valid codes:
                                         R - Regular
                                         T - Temporary
PASS_HIRES_TRFS_V   GENDER               The gender (sex) of the employee.                                                                    VARCHAR2                 2
PASS_HIRES_TRFS_V   Jobtitle             The job assignment title for this job assignment.                                                    VARCHAR2                60 DEVELOPMENT COMMUNICATIONS MANAGER            NYU_EDB_JOB      JOB_TTL_1,
                                         60-character alphanumeric (concatenated in this view, but stored as two 30-position fields Job Ttl 1                                                                                           JOB_TTL_2
                                         and Job Ttl 2 in the source table).
PASS_HIRES_TRFS_V   Reqd Object Cd       Object Code of employee                                                                                    VARCHAR2           3 100 - Admin/professional (FT)                 REQ_HDR_NYU_T REQD_OBJECT_CD
                                                                                                                                                                         102 - Faculty (FT)
PASS_HIRES_TRFS_V   Ethnicty             No longer used (see ETHNICITY_RACE).                                                                       CHAR               1 A - Native American/Amerind/Alaskan native    ISI_EDB_PER      ETHNICTY                                                              If the CNTRY code of the Organization Table                                                       Blank - Not indicated
                                                                                                                                                                                                                                                                                                              entry for this ORG is CAN, the ETHNICITY                                                          A - Native American/Amerind/Alaskan native
                                                                                                                                                                                                                                                                                                              must be 1, 2, 3, 4, or blank. Otherwise, it                                                       B - Black/African-American
                                                                                                                                                                                                                                                                                                              must be A, B, C, R, S, or blank.                                                                  C - Caucasian/White
                                                                                                                                                                                                                                                                                                                                                                                                                R - Asian/Pacific islander
                                                                                                                                                                                                                                                                                                                                                                                                                S - Hispanic/Latino
PASS_HIRES_TRFS_V   Hispanic Ind         A Y/N flag identify whether the employee has identified themselves to be of hispanic origin.               CHAR               1

PASS_HIRES_TRFS_V   Race1 Ind            A code identifying the identified ethnicity of the employee.                                               CHAR               1
PASS_HIRES_TRFS_V   Race2 Ind            See RACE1_IND (employee may identify multiple ethnicities).                                                CHAR               1
PASS_HIRES_TRFS_V   Race3 Ind            See RACE1_IND (employee may identify multiple ethnicities).                                                CHAR               1
PASS_HIRES_TRFS_V   Race4 Ind            See RACE1_IND (employee may identify multiple ethnicities).                                                CHAR               1
PASS_HIRES_TRFS_V   Race5 Ind            See RACE1_IND (employee may identify multiple ethnicities).                                                CHAR               1
PASS_HIRES_TRFS_V   Cancelled Appt Ind   Cancelled appointments                                                                                     VARCHAR2          13   Real Apt
PASS_HIRES_TRFS_V   Div Name             Hierarchy is Unit -> Division -> Department                                                                VARCHAR2          30   DIVISION OF LIBRARIES
PASS_HIRES_TRFS_V   Unit Name            Hierarchy is Unit -> Dvision -> Department                                                                 VARCHAR2          30   DIVISION OF LIBRARIES
PASS_HIRES_TRFS_V   Dept Name            The code of the department responsible for this job assignment.                                            VARCHAR2          30   RESEARCH DEVELOPMENT                        ISI_EDB_JOB      JOBDEPT
                                         5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                         Use the table look-up feature to find current values and translations.
PASS_HIRES_TRFS_V   True Officer Flag    Indicator signifying whether the position of the employee is identified as an officer of the university.   VARCHAR2          12

PASS_HIRES_TRFS_V   AS_OF_DATE           The run date of the query/report being generated.                                                          DATE
PASS_HIRES_TRFS_V   Transid              PASS Transaction ID number                                                                                 VARCHAR2          10 72199                                         REQ_HDR_NYU_T    TRANSID
PASS_HIRES_TRFS_V   Action Code          Action code number                                                                                         VARCHAR2           2 25                                            REQ_HDR_NYU_T    ACTION_CODE
PASS_HIRES_TRFS_V   Sub Action Code      Subaction code number                                                                                      VARCHAR2           3 O30                                           REQ_HDR_NYU_T    SUB_ACTION_CODE
PASS_HIRES_TRFS_V   Effective Date       Effective date of transaction                                                                                                   09/01/06 12:00 AM                             REQ_HDR_NYU_T    EFFECTIVE_DATE
PASS_HIRES_TRFS_V   Emplmtdt             Employment date. Generally this date is updated when an employee moves into/out of a benefits-             DATE                 09/01/05 12:00 AM
                                         eligible assignment.
PASS_HIRES_TRFS_V   Emp Ctgy Cd          The employee category associated with this job assignment which identifies a grouping of similar           VARCHAR2           1 F - Faculty                                   NYU_EDB_JOB      EMP_CTGY_CD         A - Administrative and Professional               N - Student
                                         jobs for reporting purposes.                                                                                                                                                                                       D - Post-Doctoral Fellows                         R - Professional Researcher
                                                                                                                                                                                                                                                            F - Faculty                                       S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                                            G - Unpaid appointments                           T - Casual employees
                                                                                                                                                                                                                                                            K - Graduate, Research, and Teaching              X - University Officers
                                                                                                                                                                                                                                                            Assistants                                        Z - Retired employees
                                                                                                                                                                                                                                                            M - Management, Directors and Academic
                                                                                                                                                                                                                                                            Administrators
PASS_HIRES_TRFS_V   Job Fmly Cd          This code identifies the general functional responsibility of this job assignment.                         CHAR               1 A - Administrative services                   NYU_EDB_JOB      JOB_FMLY_CD         1 - Finance                                       A - Administrative services                    G - General administrative support                 Q - Admissions, registration, and financial aid
                                                                                                                                                                                                                                                            2 - Communications                                B - Sergeant guards (for object code 107,      K - Communications                                 S - Survivors of retirees
                                                                                                                                                                                                                                                            3 - Institutional facilities                      117)                                           L - Library, technical, and data processing (for   T - Animal, dental/medical, media lab technicians
                                                                                                                                                                                                                                                            4 - Administrative services                       C - Elevator starters (for object code 107,    object code 100, 110)                              X - Academic administrators not in plan
                                                                                                                                                                                                                                                            5 - Student affairs                               117)                                           L - Comp, equip fab, general technical             Z - Student affairs
                                                                                                                                                                                                                                                            6 - Admissions, registration, and financial aid   D - Academic support (for object code 100,     support (for object code 104, 114)
                                                                                                                                                                                                                                                            7 - Library, technical, and data processing       110)                                           N - Institutional facilities
                                                                                                                                                                                                                                                            8 - Academic support                              D - Cdl, dental equipment repair technicians
                                                                                                                                                                                                                                                                                                              (for object code 104, 114)
                                                                                                                                                                                                                                                                                                              F - Finance




                                                                                                                                                                                                                                                                                                                                                                                                                                                  Page 17 of 28
                                                                                                                                                                                                07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


           View                  Field                                               Description                                                      Data Type   Length Example                                         Source Table        Source Field                Additional Info 1                         Additional Info 2               Additional Info 3                           Additional Info 4
PASS_HIRES_TRFS_V    Jobdept              Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be               VARCHAR2           8 43020                                       ISI_EDB_JOB       JOBDEPT
                                          from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                          Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
PASS_HIRES_TRFS_V    Aptbegdt             The date this job assignment or appointment is effective.                                                  DATE                  09/01/05 12:00 AM                          ISI_EDB_JOB       APTBEGDT                                                     To set the limit to get active appointments                       Valid formats:
                                          The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                        only                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                                       - Use APTBEGDT < sysdate and                                    MM DD YYYY
                                                                                                                                                                                                                                                                                                     APTENDDT > sysdate                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                                     To identify cancelled appointments:                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                                       - APTBEGDT = APTENDDT and                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                                     APPT_AMT = 1
PASS_HIRES_TRFS_V    Aptenddt             The date this job assignment or appointment ends.                                                          DATE                  12/31/99 12:00 AM                          ISI_EDB_JOB       APTENDDT                                                     To set the limit to get active appointments                       Valid formats:
                                          The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                        only                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                                       - Use APTBEGDT < sysdate and                                    MM DD YYYY
                                                                                                                                                                                                                                                                                                     APTENDDT > sysdate                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                                     To identify cancelled appointments:                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                                       - APTBEGDT = APTENDDT and                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                                     APPT_AMT = 1
PASS_HIRES_TRFS_V    ACTION_DESCR         A code identifying the general category of the PASS action.                                                VARCHAR2         50
PASS_HIRES_TRFS_V    SUBACTION_DESCR      A code identifying the specific category of the PASS action.                                               VARCHAR2         50
PASS_HIRES_TRFS_V    REF_CATEGORY                                                                                                                    VARCHAR2         24
PASS_HIRES_TRFS_V    COUNTER              An indicator set to 1 used for counting records for report calculations.                                   NUMBER
PASS_HIRES_TRFS_V    ETHNICITY_RACE       A calculated field identifying the ethnicity and/or race of the employee.                                  VARCHAR2          2
PASS_HIRES_TRFS_V    MINORITY_COUNT       A counter used for summary reporting employees identified as minority.                                     NUMBER
XPASS_HIRES_TRFS_V   Nyuid                University ID - System generated employee identification number used to uniquely identify                  VARCHAR2         11 N12345678
                                          employees and is not the same as the employee social security number.
XPASS_HIRES_TRFS_V   Homedept             Primary (home) department of an employee (department of the primary appointment). Jobdept is VARCHAR2                        8 56210                                        ISI_EDB_BAS       HOMEDEPT
                                          the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                          Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

XPASS_HIRES_TRFS_V   REQ_TYPE             Identifies the PASS transaction record as either containing [R]equest or [H]istorical information.         VARCHAR2          1

XPASS_HIRES_TRFS_V   Emplname             Name of employee.                                                                                          VARCHAR2         30                                              ISI_EDB_BAS       EMPLNAME
                                          Valid format: Last name, comma, first name, space, middle initial
XPASS_HIRES_TRFS_V   Emplstat             Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either               VARCHAR2          1 A
                                          = A,L, P or EMPLSTAT <> T for query/reporting limits.
XPASS_HIRES_TRFS_V   Regtemp              Indicates whether the primary job assignment of the employee is regular or temporary.                      VARCHAR2          1 R - Regular                                  ISI_EDB_BAS       REGTEMP
                                          Valid codes:
                                          R - Regular
                                          T - Temporary
XPASS_HIRES_TRFS_V   GENDER               The gender (sex) of the employee.                                                                          VARCHAR2          2
XPASS_HIRES_TRFS_V   Reqd Object Cd       Object Code of employee                                                                                    VARCHAR2          3 100 - Admin/professional (FT)                REQ_HDR_NYU_T REQD_OBJECT_CD
                                                                                                                                                                         102 - Faculty (FT)
XPASS_HIRES_TRFS_V   Ethnicty             No longer used (see ETHNICITY_RACE).                                                                       CHAR              1 A - Native American/Amerind/Alaskan native   ISI_EDB_PER       ETHNICTY                                                     If the CNTRY code of the Organization Table                       Blank - Not indicated
                                                                                                                                                                                                                                                                                                     entry for this ORG is CAN, the ETHNICITY                          A - Native American/Amerind/Alaskan native
                                                                                                                                                                                                                                                                                                     must be 1, 2, 3, 4, or blank. Otherwise, it                       B - Black/African-American
                                                                                                                                                                                                                                                                                                     must be A, B, C, R, S, or blank.                                  C - Caucasian/White
                                                                                                                                                                                                                                                                                                                                                                       R - Asian/Pacific islander
                                                                                                                                                                                                                                                                                                                                                                       S - Hispanic/Latino
XPASS_HIRES_TRFS_V   Hispanic Ind         A Y/N flag identify whether the employee has identified themselves to be of hispanic origin.               CHAR              1

XPASS_HIRES_TRFS_V   Race1 Ind            A code identifying the identified ethnicity of the employee.                                               CHAR              1
XPASS_HIRES_TRFS_V   Race2 Ind            See RACE1_IND (employee may identify multiple ethnicities).                                                CHAR              1
XPASS_HIRES_TRFS_V   Race3 Ind            See RACE1_IND (employee may identify multiple ethnicities).                                                CHAR              1
XPASS_HIRES_TRFS_V   Race4 Ind            See RACE1_IND (employee may identify multiple ethnicities).                                                CHAR              1
XPASS_HIRES_TRFS_V   Race5 Ind            See RACE1_IND (employee may identify multiple ethnicities).                                                CHAR              1
XPASS_HIRES_TRFS_V   Cancelled Appt Ind   Cancelled appointments                                                                                     VARCHAR2         13   Real Apt
XPASS_HIRES_TRFS_V   Div Name             Hierarchy is Unit -> Division -> Department                                                                VARCHAR2         30   DIVISION OF LIBRARIES
XPASS_HIRES_TRFS_V   Unit Name            Hierarchy is Unit -> Dvision -> Department                                                                 VARCHAR2         30   DIVISION OF LIBRARIES
XPASS_HIRES_TRFS_V   Dept Name            The code of the department responsible for this job assignment.                                            VARCHAR2         30   RESEARCH DEVELOPMENT                       ISI_EDB_JOB       JOBDEPT
                                          5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                          Use the table look-up feature to find current values and translations.
XPASS_HIRES_TRFS_V   True Officer Flag    Indicator signifying whether the position of the employee is identified as an officer of the university.   VARCHAR2         12

XPASS_HIRES_TRFS_V   AS_OF_DATE           The run date of the query/report being generated.                                                          DATE
XPASS_HIRES_TRFS_V   Transid              PASS Transaction ID number                                                                                 VARCHAR2         10 72199                                        REQ_HDR_NYU_T     TRANSID
XPASS_HIRES_TRFS_V   Action Code          Action code number                                                                                         VARCHAR2          2 25                                           REQ_HDR_NYU_T     ACTION_CODE
XPASS_HIRES_TRFS_V   Sub Action Code      Subaction code number                                                                                      VARCHAR2          3 O30                                          REQ_HDR_NYU_T     SUB_ACTION_CODE
XPASS_HIRES_TRFS_V   Effective Date       Effective date of transaction                                                                                                  09/01/06 12:00 AM                            REQ_HDR_NYU_T     EFFECTIVE_DATE
XPASS_HIRES_TRFS_V   Emplmtdt             Employment date. Generally this date is updated when an employee moves into/out of a benefits-             DATE                09/01/05 12:00 AM
                                          eligible assignment.
XPASS_HIRES_TRFS_V   Jobdept              Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be               VARCHAR2          8 43020                                        ISI_EDB_JOB       JOBDEPT
                                          from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                          Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
XPASS_HIRES_TRFS_V   CATEGORY                                                                                                                        CHAR             16
XPASS_HIRES_TRFS_V   CODE                 Code-Decode Value: Code                                                                                    VARCHAR2       2000
XPASS_HIRES_TRFS_V   Job Ttl 1            The job assignment title for this job assignment.                                                          CHAR             30 DEVELOPMENT COMMUNICATIONS MAN               NYU_EDB_JOB       JOB_TTL_1
                                          60-character alphanumeric (stored as two 30-position fields).
XPASS_HIRES_TRFS_V   Emp Ctgy Cd          The employee category associated with this job assignment which identifies a grouping of similar           VARCHAR2          1 F - Faculty                                  NYU_EDB_JOB       EMP_CTGY_CD         A - Administrative and Professional      N - Student
                                          jobs for reporting purposes.                                                                                                                                                                                      D - Post-Doctoral Fellows                R - Professional Researcher
                                                                                                                                                                                                                                                            F - Faculty                              S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                                            G - Unpaid appointments                  T - Casual employees
                                                                                                                                                                                                                                                            K - Graduate, Research, and Teaching     X - University Officers
                                                                                                                                                                                                                                                            Assistants                               Z - Retired employees
                                                                                                                                                                                                                                                            M - Management, Directors and Academic
                                                                                                                                                                                                                                                            Administrators




                                                                                                                                                                                                                                                                                                                                                                                                        Page 18 of 28
                                                                                                                                                                                                      07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


           View                  Field                                                    Description                                                     Data Type   Length Example                                          Source Table        Source Field   Additional Info 1                  Additional Info 2              Additional Info 3                       Additional Info 4
XPASS_HIRES_TRFS_V   Aptbegdt                    The date this job assignment or appointment is effective.                                               DATE                09/01/05 12:00 AM                             ISI_EDB_JOB       APTBEGDT                                To set the limit to get active appointments                       Valid formats:
                                                 The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                 only                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                       - Use APTBEGDT < sysdate and                                    MM DD YYYY
                                                                                                                                                                                                                                                                                     APTENDDT > sysdate                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                     To identify cancelled appointments:                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                       - APTBEGDT = APTENDDT and                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                     APPT_AMT = 1
XPASS_HIRES_TRFS_V   Aptenddt                    The date this job assignment or appointment ends.                                                       DATE                   12/31/99 12:00 AM                          ISI_EDB_JOB       APTENDDT                                To set the limit to get active appointments                       Valid formats:
                                                 The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                 only                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                       - Use APTBEGDT < sysdate and                                    MM DD YYYY
                                                                                                                                                                                                                                                                                     APTENDDT > sysdate                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                     To identify cancelled appointments:                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                       - APTBEGDT = APTENDDT and                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                     APPT_AMT = 1
XPASS_HIRES_TRFS_V   ACTION_DESC                                                                                                                         VARCHAR2       2000
XPASS_HIRES_TRFS_V   SUBACTION_DESC              A code identifying the specific category of the PASS action.                                            VARCHAR2       2000
XPASS_HIRES_TRFS_V   COUNTER                     An indicator set to 1 used for counting records for report calculations.                                NUMBER
XPASS_HIRES_TRFS_V   ETHNICITY_RACE              A calculated field identifying the ethnicity and/or race of the employee.                               VARCHAR2          2
XPASS_HIRES_TRFS_V   MINORITY_COUNT              A counter used for summary reporting employees identified as minority.                                  NUMBER
XPASS_HIRES_TRFS_V   TOTAL_MINORITY              A value of 1 indicates the employee is identified as a minority (use for EEO type reporting).           NUMBER

XPASS_HIRES_TRFS_V   ACTION                                                                                                                              VARCHAR2         32
PAY_HIST_BAS_V       Emplkey                     System generated employee key used to join adhoc views for query purposes                               VARCHAR2         35
PAY_HIST_BAS_V       Nyuid                       University ID - System generated employee identification number used to uniquely identify               VARCHAR2         11 N12345678
                                                 employees and is not the same as the employee social security number.
PAY_HIST_BAS_V       Emplname                    Name of employee.                                                                                       VARCHAR2         30                                               ISI_EDB_BAS       EMPLNAME
                                                 Valid format: Last name, comma, first name, space, middle initial
PAY_HIST_BAS_V       Checkdt                     Check date                                                                                              DATE
PAY_HIST_BAS_V       Payenddt                    Pay end date                                                                                            DATE
PAY_HIST_BAS_V       Pcheckno                    Check number                                                                                            VARCHAR2          6 321321
PAY_HIST_BAS_V       Disbtype                    Check distribution type (this field along with chkadvds determines if employee has direct deposit);     VARCHAR2          1 C - Check
                                                 A = Advice C = Check                                                                                                        A - Advice
PAY_HIST_BAS_V       Chkadvds                    Check advice distribution (this field along with disbtype determines if employee has direct deposit);   VARCHAR2          1 D - Direct deposit w/ paper advice
                                                 E = Electronic H = Home D = Dept                                                                                            H - Home
PAY_HIST_BAS_V       Paycycle                    Identifies the frequency of payment for the job assignment.                                             VARCHAR2            B1, B2 - Biweekly                                                                                                                                                         B1, B2 - Biweekly
                                                                                                                                                                             M1, M2 - Monthly                                                                                                                                                          M1, M2 - Monthly
                                                                                                                                                                             W1, W2 - Weekly                                                                                                                                                           W1, W2 - Weekly
PAY_HIST_BAS_V       Homedept                    Primary (home) department of an employee (department of the primary appointment). Jobdept is VARCHAR2                     8 56210                                         ISI_EDB_BAS       HOMEDEPT
                                                 the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                                 Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

PAY_HIST_BAS_V       Checkdt2                    Check date                                                                                              DATE
PAY_HIST_BAS_V       Pgrspay                     Gross pay for paycheck                                                                                  NUMBER          11,1
PAY_HIST_BAS_V       Lstpypdt                    Last pay date the employee was paid (from any job).                                                     DATE                09/30/08 12:00 AM
PAY_HIST_BAS_V       Payend Year Month           Format: YYYY-MM                                                                                         VARCHAR2          7
PAY_HIST_BAS_V       Check Year Month            Format: YYYY-MM                                                                                         VARCHAR2          7
PAY_HIST_BAS_V       Pay End Date Format         Format: YYYY-MM-DD                                                                                      VARCHAR2         10
PAY_HIST_BAS_V       Check Date Format           Format: YYYY-MM-DD                                                                                      VARCHAR2         10
PAY_HIST_BAS_V       Schedule                    A code identifying the payroll schedule associated with the payment to the employee.                    VARCHAR2          3
PAY_HIST_BAS_V       Advice Distribution         Electronic, Home or Dept                                                                                VARCHAR2         10
PAY_HIST_BAS_V       Schedule Last Digit         Regular or Off-Cycle pay                                                                                VARCHAR2          9
PAY_HIST_BAS_V       Check No                                                                                                                            VARCHAR2         41
PAY_HIST_BAS_V       Dist Type Check No          Disbtype + Check No                                                                                     VARCHAR2         32
PAY_HIST_BAS_V       Check Distribution Type     Direct Deposit or Check                                                                                 VARCHAR2         14
PAY_HIST_BAS_V       Checkind                    Check indicator (advice or check)                                                                       VARCHAR2          1 C - Check
                                                                                                                                                                             A - Advice
PAY_HIST_ERN_V       Emplkey                     System generated employee key used to join adhoc views for query purposes                               VARCHAR2         35
PAY_HIST_ERN_V       Nyuid                       University ID - System generated employee identification number used to uniquely identify               VARCHAR2         11 N12345678
                                                 employees and is not the same as the employee social security number.
PAY_HIST_ERN_V       Emplname                    Name of employee.                                                                                       VARCHAR2         30                                               ISI_EDB_BAS       EMPLNAME
                                                 Valid format: Last name, comma, first name, space, middle initial
PAY_HIST_ERN_V       Checkdt                     Check date                                                                                              DATE
PAY_HIST_ERN_V       Payenddt                    Pay end date                                                                                            DATE
PAY_HIST_ERN_V       Acctno                      The account number (chartfield combination) associated with the account line record.                    VARCHAR2         25 511022153100
PAY_HIST_ERN_V       Earntype                    Identifies the type of payments or deductions or reductions associated with this account line.          CHAR              3 R12
                                                 Required.
                                                 3-character alphanumeric.
                                                 Valid codes are listed on the Earnings Table.
                                                 Examples: OTS - Overtime pay
                                                 REG - Regular pay
                                                 RSK - Sick leave
                                                 RVC - Vacation


PAY_HIST_ERN_V       Earnings Type Translation   Earnings type                                                                                           CHAR             18 Regular Pay
PAY_HIST_ERN_V       Perntime                    Hours for earnings type                                                                                 NUMBER            5 25
PAY_HIST_ERN_V       Earnamt                     Earnings amount for earnings type                                                                       NUMBER           11
PAY_HIST_ERN_V       Payend Year Month           Format: YYYY-MM                                                                                         VARCHAR2          7
PAY_HIST_ERN_V       Check Year Month            Format: YYYY-MM                                                                                         VARCHAR2          7
PAY_HIST_ERN_V       Pay End Date Format         Format: YYYY-MM-DD                                                                                      VARCHAR2         10
PAY_HIST_ERN_V       Check Date Format           Format: YYYY-MM-DD                                                                                      VARCHAR2         10
PAY_HIST_ERN_V       Checkind                    Check indicator (advice or check)                                                                       VARCHAR2          1 C - Check
                                                                                                                                                                             A - Advice
PAY_HIST_ERN_V       Pcheckno                    Check number                                                                                            VARCHAR2         22 321321
PAY_HIST_ERN_V       Rcdno                       Record number                                                                                           VARCHAR2         22
PAY_HIST_ERN_V       Account                     Used to derive chartfield (Account + Fund Code + Deptid + Program Code)                                 VARCHAR2          6 51102
PAY_HIST_ERN_V       Fund_Code                   Used to derive chartfield (Account + Fund Code + Deptid + Program Code)                                 VARCHAR2          5 10
PAY_HIST_ERN_V       Deptid                      Used to derive chartfield (Account + Fund Code + Deptid + Program Code)                                 VARCHAR2         10 53100



                                                                                                                                                                                                                                                                                                                                                                                   Page 19 of 28
                                                                                                                                                                                         07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


           View               Field                                               Description                                              Data Type   Length    Example                                        Source Table         Source Field                   Additional Info 1                               Additional Info 2                                Additional Info 3                                            Additional Info 4
PAY_HIST_ERN_V    Program_Code         Used to derive chartfield (Account + Fund Code + Deptid + Program Code)                            VARCHAR2           5   SL123
PAY_HIST_ERN_V    Project Id                                                                                                              VARCHAR2         15
PAY_HIST_ERN_V    Hrsind                                                                                                                  VARCHAR2           1
PAY_HIST_ERN_V    Payrate              Identifies the job rate of pay per pay cycle of the employee.                                      NUMBER           11
PAY_HIST_ERN_V    Ratecode             P or H                                                                                             VARCHAR2           1
PAY_HIST_ERN_V    Pctfull                                                                                                                 NUMBER             5
SEPARATIONS_V     Action Code          Action code number                                                                                 VARCHAR2           2   25                                           REQ_HDR_NYU_T ACTION_CODE
SEPARATIONS_V     Sub Action Code      Subaction code number                                                                              VARCHAR2           3   O30                                          REQ_HDR_NYU_T SUB_ACTION_CODE
SEPARATIONS_V     Effective Date       Effective date of transaction                                                                                             09/01/06 12:00 AM                            REQ_HDR_NYU_T EFFECTIVE_DATE
SEPARATIONS_V     AS_OF_DATE           The run date of the query/report being generated.                                                  DATE
SEPARATIONS_V     Page Name            PASS page name                                                                                     VARCHAR2         30 Account Changes                                 REQ_HDR_NYU_T PAGE_NAME
SEPARATIONS_V     Reqd Object Cd       Object Code of employee                                                                            VARCHAR2          3 100 - Admin/professional (FT)                   REQ_HDR_NYU_T REQD_OBJECT_CD
                                                                                                                                                              102 - Faculty (FT)
SEPARATIONS_V     Reqd Emplname        Name of employee.                                                                                  VARCHAR2         30                                                 ISI_EDB_BAS      EMPLNAME
                                       30-character alphanumeric.
                                       Valid format:
                                       Last name, comma, first name, space, middle initial
SEPARATIONS_V     Emplname             Name of employee.                                                                                  VARCHAR2         30                                                 ISI_EDB_BAS      EMPLNAME
                                       Valid format: Last name, comma, first name, space, middle initial
SEPARATIONS_V     Complete Job Title   The total 60 character concatenated job title.                                                     CHAR             60
SEPARATIONS_V     Object Cd            Identifies the general type of work performed and the full-time/part-time status for the PRIMARY   INTEGER                100 - Admin/professional (FT)                NYU_EDB_EMP_T OBJECT_CD                                                                                                                 JOB_OBJECT_CD (OBJECT_CD on                        100 - Admin/professional (FT)
                                       (job #1) assignment of the employee.                                                                                      102 - Faculty (FT)                                                                 110 - Admin/professional (PT)                                                                     NYU_EDB_JOB_T) is the object code of the           101 - Teaching or graduate assistant (FT)
                                                                                                                                                                                                                                                    111 - Grader, tutor, lab assistant (PT)           118 - Student (workstudy)                       particular job. Use the Object Code from the       102 - Faculty (FT)
                                                                                                                                                                                                                                                    112 - Faculty (PT)                                119 - Student (non-workstudy)                   Emp_T table if you are looking at primary          103 - Professional researcher (FT)
                                                                                                                                                                                                                                                    113 - Professional researcher (PT)                130 - Research assistant (FT)                   jobs, use the object code from the Job_T           104 - Laboratory/technical staff (FT)
                                                                                                                                                                                                                                                    114 - Laboratory/technical staff (PT)             131 - Research assistant (FT)                   table if you are looking at the object codes of    106 - Office/clerical staff (FT)
                                                                                                                                                                                                                                                    115 - Casual employee (PT)                        542 - Post-doctoral fellow (FT)                 all jobs.                                          107 - Service staff (FT)
                                                                                                                                                                                                                                                    116 - Office/clerical staff (PT)
                                                                                                                                                                                                                                                    117 - Service staff (PT)

SEPARATIONS_V     Job Object Cd        JOB_OBJECT_CD, which is listed as field OBJECT_CD on the NYU_EDB_JOB_T table is the                INTEGER                100 - Admin/professional (FT)                NYU_EDB_JOB_T    OBJECT_CD            OBJECT_CD, which is listed as field               Use the Object Code from the Emp_T table if
                                       object code of the particular job- each job has one.                                                                      102 - Faculty (FT)                                                                 OBJECT_CD on the NYU_EDB_EMP_T table,             you are only looking at primary jobs, use the
                                                                                                                                                                                                                                                    is the object code of the primary job and is      object code from the Job_T table if you are
                                                                                                                                                                                                                                                    defaulted from the Object Code of Job #1.         looking at the object codes of all jobs.

SEPARATIONS_V     ACTION_DESCR         A code identifying the general category of the PASS action.                                        VARCHAR2         50
SEPARATIONS_V     SUBACTION_DESCR      A code identifying the specific category of the PASS action.                                       VARCHAR2         50
SEPARATIONS_V     Nyuid                University ID - System generated employee identification number used to uniquely identify          VARCHAR2         11 N12345678
                                       employees and is not the same as the employee social security number.
SEPARATIONS_V     Homedept             Primary (home) department of an employee (department of the primary appointment). Jobdept is       VARCHAR2          8 56210                                           ISI_EDB_BAS      HOMEDEPT
                                       the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                       Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

SEPARATIONS_V     Jobdept              Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be       VARCHAR2          8 43020                                           ISI_EDB_JOB      JOBDEPT
                                       from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                       Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
SEPARATIONS_V     Jobclass             The job classification code assigned to this job assignment.                                       VARCHAR2          6 220163                                          ISI_EDB_JOB      JOBCLASS
                                       Can be decoded using HR.ISI_CDB_JOB_T table.
                                       6-character alphanumeric.
                                       Use the table look-up feature to find current values and translations.
SEPARATIONS_V     Lstpypdt             Last pay date the employee was paid (from any job).                                             DATE                      09/30/08 12:00 AM
SEPARATIONS_V     Prty Cd              Priority code of 1 should be assigned to the primary job assignment. An employee can have up to INTEGER                   1                                            NYU_EDB_JOB      PRTY_CD
                                       7 jobs and must have one appointment with priority 1. No two appointments may have the same
                                       priority. Job priority 7 is for Payroll use only.
SEPARATIONS_V     Emplstat             Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either       VARCHAR2          1 A
                                       = A,L, P or EMPLSTAT <> T for query/reporting limits.
SEPARATIONS_V     Dept Name            The code of the department responsible for this job assignment.                                    VARCHAR2         30 RESEARCH DEVELOPMENT                            ISI_EDB_JOB      JOBDEPT
                                       5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                       Use the table look-up feature to find current values and translations.
SEPARATIONS_V     Unit Name            Hierarchy is Unit -> Dvision -> Department                                                         VARCHAR2         30 DIVISION OF LIBRARIES
SEPARATIONS_V     Div Name             Hierarchy is Unit -> Division -> Department                                                        VARCHAR2         30 DIVISION OF LIBRARIES
SEPARATIONS_V     Regtemp              Indicates whether the primary job assignment of the employee is regular or temporary.              VARCHAR2          1 R - Regular                                     ISI_EDB_BAS      REGTEMP
                                       Valid codes:
                                       R - Regular
                                       T - Temporary
SEPARATIONS_V     Job Fmly Cd          This code identifies the general functional responsibility of this job assignment.                 CHAR              1 A - Administrative services                     NYU_EDB_JOB      JOB_FMLY_CD          1 - Finance                                       A - Administrative services                     G - General administrative support                 Q - Admissions, registration, and financial aid
                                                                                                                                                                                                                                                    2 - Communications                                B - Sergeant guards (for object code 107,       K - Communications                                 S - Survivors of retirees
                                                                                                                                                                                                                                                    3 - Institutional facilities                      117)                                            L - Library, technical, and data processing (for   T - Animal, dental/medical, media lab technicians
                                                                                                                                                                                                                                                    4 - Administrative services                       C - Elevator starters (for object code 107,     object code 100, 110)                              X - Academic administrators not in plan
                                                                                                                                                                                                                                                    5 - Student affairs                               117)                                            L - Comp, equip fab, general technical             Z - Student affairs
                                                                                                                                                                                                                                                    6 - Admissions, registration, and financial aid   D - Academic support (for object code 100,      support (for object code 104, 114)
                                                                                                                                                                                                                                                    7 - Library, technical, and data processing       110)                                            N - Institutional facilities
                                                                                                                                                                                                                                                    8 - Academic support                              D - Cdl, dental equipment repair technicians
                                                                                                                                                                                                                                                                                                      (for object code 104, 114)
                                                                                                                                                                                                                                                                                                      F - Finance

SEPARATIONS_V     Seprtn Dt            Date the employee was separated.                                                                   DATE                   01/01/01 12:00 AM                            NYU_EDB_EMP      SEPRTN_DT
                                       10-character alphanumeric (maximum).
                                       Valid formats:
                                       MMDDCCYY
                                       MM DD CCYY
                                       MM/DD/CCYY
                                       MM-DD-CCYY
                                       MM.DD.CCYY
SEPARATIONS_V     Sex                  Th sex of the employee.                                                                            CHAR              1 M                                               ISI_EDB_PER      SEX
                                       Valid codes:
                                       F - Female
                                       M - Male




                                                                                                                                                                                                                                                                                                                                                                                                                                           Page 20 of 28
                                                                                                                                                                                     07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View              Field                                                Description                                            Data Type   Length Example                                           Source Table        Source Field                   Additional Info 1                                 Additional Info 2                             Additional Info 3                                              Additional Info 4
SEPARATIONS_V    Ethnicty           No longer used (see ETHNICITY_RACE).                                                               CHAR               1 A - Native American/Amerind/Alaskan native    ISI_EDB_PER       ETHNICTY                                                              If the CNTRY code of the Organization Table                                                       Blank - Not indicated
                                                                                                                                                                                                                                                                                                  entry for this ORG is CAN, the ETHNICITY                                                          A - Native American/Amerind/Alaskan native
                                                                                                                                                                                                                                                                                                  must be 1, 2, 3, 4, or blank. Otherwise, it                                                       B - Black/African-American
                                                                                                                                                                                                                                                                                                  must be A, B, C, R, S, or blank.                                                                  C - Caucasian/White
                                                                                                                                                                                                                                                                                                                                                                                                    R - Asian/Pacific islander
                                                                                                                                                                                                                                                                                                                                                                                                    S - Hispanic/Latino
SEPARATIONS_V    Race1 Ind          A code identifying the identified ethnicity of the employee.                                       CHAR               1
SEPARATIONS_V    Race2 Ind          See RACE1_IND (employee may identify multiple ethnicities).                                        CHAR               1
SEPARATIONS_V    Race3 Ind          See RACE1_IND (employee may identify multiple ethnicities).                                        CHAR               1
SEPARATIONS_V    Race4 Ind          See RACE1_IND (employee may identify multiple ethnicities).                                        CHAR               1
SEPARATIONS_V    Race5 Ind          See RACE1_IND (employee may identify multiple ethnicities).                                        CHAR               1
SEPARATIONS_V    Hispanic Ind       A Y/N flag identify whether the employee has identified themselves to be of hispanic origin.       CHAR               1

SEPARATIONS_V    COUNTER            An indicator set to 1 used for counting records for report calculations.                           NUMBER
SEPARATIONS_V    EMP_COUNT          An indicator set to 1 used for counting records for report calculations.                           NUMBER
SEPARATIONS_V    CALENDAR_YEAR      The calendar year in which the separation was effective.                                           VARCHAR2           4
SEPARATIONS_V    Effective Month    Effective month of transaction                                                                     VARCHAR2           2
SEPARATIONS_V    NEW_DATE           The effective date of the separation in the format MM/DD/YY.                                       VARCHAR2           8
SEPARATIONS_V    NEW_MONTH          The month of the sepration in the format MM.                                                       VARCHAR2           2
SEPARATIONS_V    FISCAL_YEAR        The fiscal year in which the sepation was effective.                                               VARCHAR2           4
SEPARATIONS_V    ETHNICITY_RACE     A calculated field identifying the ethnicity and/or race of the employee.                          VARCHAR2           2
VAC_SICK_BAL_V   Emplname           Name of employee.                                                                                  VARCHAR2          30                                               ISI_EDB_BAS       EMPLNAME
                                    Valid format: Last name, comma, first name, space, middle initial
VAC_SICK_BAL_V   Jobdept            Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be       VARCHAR2           8 43020                                         ISI_EDB_JOB       JOBDEPT
                                    from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                    Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
VAC_SICK_BAL_V   Nyuid              University ID - System generated employee identification number used to uniquely identify    VARCHAR2                11 N12345678
                                    employees and is not the same as the employee social security number.
VAC_SICK_BAL_V   Homedept           Primary (home) department of an employee (department of the primary appointment). Jobdept is VARCHAR2                 8 56210                                         ISI_EDB_BAS       HOMEDEPT
                                    the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                    Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

VAC_SICK_BAL_V   Aptbegdt           The date this job assignment or appointment is effective.                                          DATE                   09/01/05 12:00 AM                           ISI_EDB_JOB       APTBEGDT                                                              To set the limit to get active appointments                                                       Valid formats:
                                    The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                           only                                                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                                    - Use APTBEGDT < sysdate and                                                                    MM DD YYYY
                                                                                                                                                                                                                                                                                                  APTENDDT > sysdate                                                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                                  To identify cancelled appointments:                                                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                                    - APTBEGDT = APTENDDT and                                                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                                  APPT_AMT = 1
VAC_SICK_BAL_V   Aptenddt           The date this job assignment or appointment ends.                                                  DATE                   12/31/99 12:00 AM                           ISI_EDB_JOB       APTENDDT                                                              To set the limit to get active appointments                                                       Valid formats:
                                    The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                           only                                                                                              MMDDYYYY
                                                                                                                                                                                                                                                                                                    - Use APTBEGDT < sysdate and                                                                    MM DD YYYY
                                                                                                                                                                                                                                                                                                  APTENDDT > sysdate                                                                                MM/DD/YYYY
                                                                                                                                                                                                                                                                                                  To identify cancelled appointments:                                                               MM-DD-YYYY
                                                                                                                                                                                                                                                                                                    - APTBEGDT = APTENDDT and                                                                       MM.DD.YYYY
                                                                                                                                                                                                                                                                                                  APPT_AMT = 1
VAC_SICK_BAL_V   Jobclass           The job classification code assigned to this job assignment.                                       VARCHAR2           6 220163                                        ISI_EDB_JOB       JOBCLASS
                                    Can be decoded using HR.ISI_CDB_JOB_T table.
                                    6-character alphanumeric.
                                    Use the table look-up feature to find current values and translations.
VAC_SICK_BAL_V   Lstpypdt           Last pay date the employee was paid (from any job).                                             DATE                      09/30/08 12:00 AM
VAC_SICK_BAL_V   Prty Cd            Priority code of 1 should be assigned to the primary job assignment. An employee can have up to INTEGER                   1                                           NYU_EDB_JOB       PRTY_CD
                                    7 jobs and must have one appointment with priority 1. No two appointments may have the same
                                    priority. Job priority 7 is for Payroll use only.
VAC_SICK_BAL_V   Emplstat           Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either       VARCHAR2           1 A
                                    = A,L, P or EMPLSTAT <> T for query/reporting limits.
VAC_SICK_BAL_V   Regtemp            Indicates whether the primary job assignment of the employee is regular or temporary.              VARCHAR2           1 R - Regular                                   ISI_EDB_BAS       REGTEMP
                                    Valid codes:
                                    R - Regular
                                    T - Temporary
VAC_SICK_BAL_V   Job Fmly Cd        This code identifies the general functional responsibility of this job assignment.                 CHAR               1 A - Administrative services                   NYU_EDB_JOB       JOB_FMLY_CD         1 - Finance                                       A - Administrative services                    G - General administrative support                 Q - Admissions, registration, and financial aid
                                                                                                                                                                                                                                                2 - Communications                                B - Sergeant guards (for object code 107,      K - Communications                                 S - Survivors of retirees
                                                                                                                                                                                                                                                3 - Institutional facilities                      117)                                           L - Library, technical, and data processing (for   T - Animal, dental/medical, media lab technicians
                                                                                                                                                                                                                                                4 - Administrative services                       C - Elevator starters (for object code 107,    object code 100, 110)                              X - Academic administrators not in plan
                                                                                                                                                                                                                                                5 - Student affairs                               117)                                           L - Comp, equip fab, general technical             Z - Student affairs
                                                                                                                                                                                                                                                6 - Admissions, registration, and financial aid   D - Academic support (for object code 100,     support (for object code 104, 114)
                                                                                                                                                                                                                                                7 - Library, technical, and data processing       110)                                           N - Institutional facilities
                                                                                                                                                                                                                                                8 - Academic support                              D - Cdl, dental equipment repair technicians
                                                                                                                                                                                                                                                                                                  (for object code 104, 114)
                                                                                                                                                                                                                                                                                                  F - Finance

VAC_SICK_BAL_V   Emp Ctgy Cd        The employee category associated with this job assignment which identifies a grouping of similar   VARCHAR2           1 F - Faculty                                   NYU_EDB_JOB       EMP_CTGY_CD         A - Administrative and Professional               N - Student
                                    jobs for reporting purposes.                                                                                                                                                                                D - Post-Doctoral Fellows                         R - Professional Researcher
                                                                                                                                                                                                                                                F - Faculty                                       S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                                G - Unpaid appointments                           T - Casual employees
                                                                                                                                                                                                                                                K - Graduate, Research, and Teaching              X - University Officers
                                                                                                                                                                                                                                                Assistants                                        Z - Retired employees
                                                                                                                                                                                                                                                M - Management, Directors and Academic
                                                                                                                                                                                                                                                Administrators
VAC_SICK_BAL_V   Hr Rep Name        The name of the HR Officer (primary job) of an employee.                                             VARCHAR2        30
VAC_SICK_BAL_V   Jobtitle           The job assignment title for this job assignment.                                                    VARCHAR2        60 DEVELOPMENT COMMUNICATIONS MANAGER            NYU_EDB_JOB       JOB_TTL_1,
                                    60-character alphanumeric (concatenated in this view, but stored as two 30-position fields Job Ttl 1                                                                                    JOB_TTL_2
                                    and Job Ttl 2 in the source table).
VAC_SICK_BAL_V   Emplid             Social Security Number of employee                                                                   INTEGER              111223333
VAC_SICK_BAL_V   Qtrno              Quarter Number - The field qtrno should be =0 in most queries but in the actual table in HRIS it can                      0
                                    also be a 4 (for tax purposes).
VAC_SICK_BAL_V   Chk Lctn Cd        Check location code                                                                                  VARCHAR2         2 01




                                                                                                                                                                                                                                                                                                                                                                                                                                      Page 21 of 28
                                                                                                                                                                                         07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


           View               Field                                                Description                                         Data Type       Length Example                                           Source Table        Source Field                  Additional Info 1                              Additional Info 2                               Additional Info 3                                            Additional Info 4
VAC_SICK_BAL_V    Emplmtdt             Employment date. Generally this date is updated when an employee moves into/out of a benefits- DATE                    09/01/05 12:00 AM
                                       eligible assignment.
VAC_SICK_BAL_V    Wrk Hrs              The standard work hours for the employee in a normal work week. This number is used to         NUMBER               4,2 35
                                       determine the correct accrual rate for vacation and sick leave.
                                       4-digit numeric.
                                       Formatted 99.99.
                                       Valid values: 00.00 - 40.00.
VAC_SICK_BAL_V    Dept Name            The code of the department responsible for this job assignment.                                      VARCHAR2       30 RESEARCH DEVELOPMENT                            ISI_EDB_JOB      JOBDEPT
                                       5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                       Use the table look-up feature to find current values and translations.
VAC_SICK_BAL_V    Unit Name            Hierarchy is Unit -> Dvision -> Department                                                           VARCHAR2       30 DIVISION OF LIBRARIES
VAC_SICK_BAL_V    Div Name             Hierarchy is Unit -> Division -> Department                                                          VARCHAR2       30 DIVISION OF LIBRARIES
VAC_SICK_BAL_V    Job Object Cd        JOB_OBJECT_CD, which is listed as field OBJECT_CD on the NYU_EDB_JOB_T table is the                  INTEGER           100 - Admin/professional (FT)                   NYU_EDB_JOB_T    OBJECT_CD           OBJECT_CD, which is listed as field             Use the Object Code from the Emp_T table if
                                       object code of the particular job- each job has one.                                                                   102 - Faculty (FT)                                                                   OBJECT_CD on the NYU_EDB_EMP_T table,           you are only looking at primary jobs, use the
                                                                                                                                                                                                                                                   is the object code of the primary job and is    object code from the Job_T table if you are
                                                                                                                                                                                                                                                   defaulted from the Object Code of Job #1.       looking at the object codes of all jobs.

VAC_SICK_BAL_V    Jobno                JobNo is the physical number of the job in the database; Prty_Cd is the priority of the job. JobNo   DATE                 1                                            ISI_EDB_JOB,     JOBNO
                                       gets reset nightly to the Prty_Cd. Use Prty_Cd instead of JobNo. An employee can have up to 7                                                                          ISI_EDB_ACC,
                                       jobs. Job #7 is for Payroll use only.                                                                                                                                  NYU_EDB_JOB,
                                                                                                                                                                                                              NYU_EDB_ACT
VAC_SICK_BAL_V    Cancelled Appt Ind   Cancelled appointments                                                                               VARCHAR2       13 Real Apt
VAC_SICK_BAL_V    Bldng Addr           Work Location of Employee - Address                                                                  CHAR           30
VAC_SICK_BAL_V    Room No              Work Location of employee - Room No                                                                  VARCHAR2        5
VAC_SICK_BAL_V    Payterm              Identifies the length of the job assignment and the period of payment.                               VARCHAR2          02 - 10-month assignment paid over 12 months    ISI_EDB_JOB      PAYTERM             00 - 10-month assignment paid over 10 months    90 - 9-month assignment paid over 10                                                              97 - 4 1/2 month assignment paid over 7 months (spring)
                                                                                                                                                                                                                                                   01-09 - specific number of payments for temp.   months                                                                                            98 - 9-month assignment paid over 8 months
                                                                                                                                                                                                                                                   appt.                                           92 - 9-month assignment paid over 12
                                                                                                                                                                                                                                                   02 - 10-month assignment paid over 12 months    months
                                                                                                                                                                                                                                                   12 - 11-month assignment paid over 12 months    94 - 4 1/2 month assignment paid over 4
                                                                                                                                                                                                                                                   22 - 12-month assignment paid over 12 months    months (fall, spring)
                                                                                                                                                                                                                                                                                                   96 - 4 1/2 month assignment paid over 6
                                                                                                                                                                                                                                                                                                   months (fall)



VAC_SICK_BAL_V    Paycycle             Identifies the frequency of payment for the job assignment.                                          VARCHAR2             B1, B2 - Biweekly                            ISI_EDB_JOB      PAYCYCLE                                                                                                                                                              B1, B2 - Biweekly
                                                                                                                                                                 M1, M2 - Monthly                                                                                                                                                                                                                    M1, M2 - Monthly
                                                                                                                                                                 W1, W2 - Weekly                                                                                                                                                                                                                     W1, W2 - Weekly
VAC_SICK_BAL_V    Run Date             Date report was run
VAC_SICK_BAL_V    HRSBAL01             FYTD balance of vacation hours.                                                                      NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL01
VAC_SICK_BAL_V    HRSBAL02             YTD hours of sick balances                                                                           NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL02
VAC_SICK_BAL_V    HRSBAL03             FYTD hours of vacation days taken                                                                    NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL03
VAC_SICK_BAL_V    HRSBAL04             YTD hours of sick days taken                                                                         NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL04
VAC_SICK_BAL_V    HRSBAL12             FYTD hours of vacation earned                                                                        NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL12
VAC_SICK_BAL_V    HRSBAL13             YTD sick days earned                                                                                 NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL13
VAC_SICK_BAL_V    HRSBAL39             FYTD accrued vacation days                                                                           NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL39
VAC_SICK_BAL_V    HRSBAL45             FYTD Personal leave taken                                                                            NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL45
VAC_SICK_BAL_V    HRSBAL50             FY carry over from previous fiscal year (August ending balance)                                      NUMBER         9,2                                                ISI_EDB_HRS_T    HRSBAL50
VAC_SICK_BAL_V    GRS61                YTD sick days payments                                                                               NUMBER        11,1                                                ISI_EDB_GRS_T    GRS61
VAC_SICK_BAL_V    GRS103               YTD vacation days payments                                                                           NUMBER        11,1                                                ISI_EDB_GRS_T    GRS103
EMPLOYMENT_VW     Emplid               Social Security Number of employee                                                                   INTEGER           111223333
EMPLOYMENT_VW     Nyuid                University ID - System generated employee identification number used to uniquely identify            VARCHAR2       11 N12345678
                                       employees and is not the same as the employee social security number.
EMPLOYMENT_VW     Emplname             Name of employee.                                                                                    VARCHAR2       30                                                 ISI_EDB_BAS      EMPLNAME
                                       Valid format: Last name, comma, first name, space, middle initial
EMPLOYMENT_VW     Job Ttl 1            The job assignment title for this job assignment.                                                    CHAR           30 DEVELOPMENT COMMUNICATIONS MAN                  NYU_EDB_JOB      JOB_TTL_1
                                       60-character alphanumeric (stored as two 30-position fields).
EMPLOYMENT_VW     Job Ttl 2            The job assignment title for this job assignment.                                                    CHAR           30 AGER                                            NYU_EDB_JOB      JOB_TTL_2
                                       60-character alphanumeric (stored as two 30-position fields).
EMPLOYMENT_VW     Jobdept              Dept for a particular job of an employee. An employee can have up to 7 jobs. Each job can be         VARCHAR2        8 43020                                           ISI_EDB_JOB      JOBDEPT
                                       from a different or the same dept. Home dept is defaulted based on the jobdept of job #1.
                                       Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.
EMPLOYMENT_VW     Dept Name            The code of the department responsible for this job assignment.                                      VARCHAR2       30 RESEARCH DEVELOPMENT                            ISI_EDB_JOB      JOBDEPT
                                       5-digit numeric. Hierarchy is Unit -> Dvision -> Department
                                       Use the table look-up feature to find current values and translations.
EMPLOYMENT_VW     Homedept             Primary (home) department of an employee (department of the primary appointment). Jobdept is VARCHAR2                8 56210                                           ISI_EDB_BAS      HOMEDEPT
                                       the department of a particular job. Home dept is defaulted based on the Jobdept of job #1.
                                       Decode values can be found on the HR.DEPT_DIV_UNIT_REP_T table.

EMPLOYMENT_VW     Jobno                JobNo is the physical number of the job in the database; Prty_Cd is the assigned priority of the     DATE                 1                                            ISI_EDB_JOB,     JOBNO
                                       job. JobNo gets reset nightly to match Prty_Cd. Use Prty_Cd instead of JobNo. An employee                                                                              ISI_EDB_ACC,
                                       can have up to 7 jobs. Job #7 is for Payroll use only.                                                                                                                 NYU_EDB_JOB,
                                                                                                                                                                                                              NYU_EDB_ACT
EMPLOYMENT_VW     Prty Cd              Priority code of 1 should be assigned to the primary job assignment. An employee can have up to INTEGER                   1                                            NYU_EDB_JOB      PRTY_CD
                                       7 jobs and must have one appointment with priority 1. No two appointments may have the same
                                       priority. Job priority 7 is for Payroll use only.
EMPLOYMENT_VW     Emplmtdt             Employment date. Generally this date is updated when an employee moves into/out of a benefits- DATE                       09/01/05 12:00 AM
                                       eligible assignment.
EMPLOYMENT_VW     Object Cd            Identifies the general type of work performed and the full-time/part-time status for the PRIMARY INTEGER                  100 - Admin/professional (FT)                NYU_EDB_EMP_T OBJECT_CD                                                                                                              JOB_OBJECT_CD (OBJECT_CD on                       100 - Admin/professional (FT)
                                       (job #1) assignment of the employee.                                                                                      102 - Faculty (FT)                                                                110 - Admin/professional (PT)                                                                   NYU_EDB_JOB_T) is the object code of the          101 - Teaching or graduate assistant (FT)
                                                                                                                                                                                                                                                   111 - Grader, tutor, lab assistant (PT)         118 - Student (workstudy)                       particular job. Use the Object Code from the      102 - Faculty (FT)
                                                                                                                                                                                                                                                   112 - Faculty (PT)                              119 - Student (non-workstudy)                   Emp_T table if you are looking at primary         103 - Professional researcher (FT)
                                                                                                                                                                                                                                                   113 - Professional researcher (PT)              130 - Research assistant (FT)                   jobs, use the object code from the Job_T          104 - Laboratory/technical staff (FT)
                                                                                                                                                                                                                                                   114 - Laboratory/technical staff (PT)           131 - Research assistant (FT)                   table if you are looking at the object codes of   106 - Office/clerical staff (FT)
                                                                                                                                                                                                                                                   115 - Casual employee (PT)                      542 - Post-doctoral fellow (FT)                 all jobs.                                         107 - Service staff (FT)
                                                                                                                                                                                                                                                   116 - Office/clerical staff (PT)
                                                                                                                                                                                                                                                   117 - Service staff (PT)




                                                                                                                                                                                                                                                                                                                                                                                                                                       Page 22 of 28
                                                                                                                                                                                     07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View              Field                                                Description                                          Data Type       Length Example                                        Source Table        Source Field                   Additional Info 1                              Additional Info 2                                  Additional Info 3                                          Additional Info 4
EMPLOYMENT_VW    Job Object Cd       JOB_OBJECT_CD identifies the general type of work performed and the full-time part-time status INTEGER                  100 - Admin/professional (FT)                NYU_EDB_JOB_T    OBJECT_CD           OBJECT_CD, which is listed as field             Use the Object Code from the Emp_T table if
                                     for a particular job of an employee; based on the Jobno or Prty Cd of the record.                                       102 - Faculty (FT)                                                                OBJECT_CD on the NYU_EDB_EMP_T table,           you are only looking at primary jobs, use the
                                                                                                                                                                                                                                               is the object code of the primary job and is    object code from the Job_T table if you are
                                                                                                                                                                                                                                               defaulted from the Object Code of Job #1.       looking at the object codes of all jobs.

EMPLOYMENT_VW    Range               A numeric salary ranking assigned to most administrative, technical and clerical assignments;         VARCHAR2         2 OC 104, 114 -> Grade Blank; 40 - 45         ISI_EDB_JOB      RANGE                                                               OC 101, 111, 102, 112, 103, 113, 115, 118,
                                     known as the grade of the job.                                                                                                                                                                                                                            119, 107, 117, 130, 131, 542 -> Grade Blank
                                                                                                                                                                                                                                                                                               OC 100, 110 -> Grade Blank; 11 - 21
                                                                                                                                                                                                                                                                                               OC 104, 114 -> Grade Blank; 40 - 45
                                                                                                                                                                                                                                                                                               OC 106, 116 -> Grade Blank; 1, 2, 3, 5 - 10



EMPLOYMENT_VW    Emplstat            Employment status: A,L,P,T,X are potential employee statuses. Typically use: EMPLSTAT either          VARCHAR2         1 A
                                     = A,L, P or EMPLSTAT <> T for query/reporting limits.
EMPLOYMENT_VW    Regtemp             Indicates whether the primary job assignment of the employee is regular or temporary.                 VARCHAR2         1 R - Regular                                 ISI_EDB_BAS      REGTEMP
                                     Valid codes:
                                     R - Regular
                                     T - Temporary
EMPLOYMENT_VW    Aptbegdt            The date this job assignment or appointment is effective.                                             DATE               09/01/05 12:00 AM                           ISI_EDB_JOB      APTBEGDT                                                            To set the limit to get active appointments                                                          Valid formats:
                                     The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                       only                                                                                                 MMDDYYYY
                                                                                                                                                                                                                                                                                                 - Use APTBEGDT < sysdate and                                                                       MM DD YYYY
                                                                                                                                                                                                                                                                                               APTENDDT > sysdate                                                                                   MM/DD/YYYY
                                                                                                                                                                                                                                                                                               To identify cancelled appointments:                                                                  MM-DD-YYYY
                                                                                                                                                                                                                                                                                                 - APTBEGDT = APTENDDT and                                                                          MM.DD.YYYY
                                                                                                                                                                                                                                                                                               APPT_AMT = 1
EMPLOYMENT_VW    Aptenddt            The date this job assignment or appointment ends.                                                     DATE               12/31/99 12:00 AM                           ISI_EDB_JOB      APTENDDT                                                            To set the limit to get active appointments                                                          Valid formats:
                                     The job BEGIN DT must be earlier than (or equal to) the job END DT.                                                                                                                                                                                       only                                                                                                 MMDDYYYY
                                                                                                                                                                                                                                                                                                 - Use APTBEGDT < sysdate and                                                                       MM DD YYYY
                                                                                                                                                                                                                                                                                               APTENDDT > sysdate                                                                                   MM/DD/YYYY
                                                                                                                                                                                                                                                                                               To identify cancelled appointments:                                                                  MM-DD-YYYY
                                                                                                                                                                                                                                                                                                 - APTBEGDT = APTENDDT and                                                                          MM.DD.YYYY
                                                                                                                                                                                                                                                                                               APPT_AMT = 1
EMPLOYMENT_VW    Jobclass            The job classification code assigned to this job assignment.                                          VARCHAR2         6 220163                                      ISI_EDB_JOB      JOBCLASS
                                     Can be decoded using HR.ISI_CDB_JOB_T table.
                                     6-character alphanumeric.
                                     Use the table look-up feature to find current values and translations.
EMPLOYMENT_VW    Jobtitle            The job assignment title for this job assignment.                                                    VARCHAR2         60 DEVELOPMENT COMMUNICATIONS MANAGER          NYU_EDB_JOB      JOB_TTL_1,
                                     60-character alphanumeric (concatenated in this view, but stored as two 30-position fields Job Ttl 1                                                                                  JOB_TTL_2
                                     and Job Ttl 2 in the source table).
EMPLOYMENT_VW    Appt Amt            This field is calculated based on PAY TERM, PAY RATE, and PAY CYCLE. Appt Amount is stored NUMBER                    9,3 30,000.00                                   NYU_EDB_JOB      APPT_AMT            This field is calculated based on PAY TERM,     OC 100,110 -> B1 pay cycle -> any pay term -        When ApptAmt=$1.00, employee will not be         OC 102,112,103,113 -> 22,92 pay term -> appt amt = PAY RATE x
                                     as annual base, monthly pay, weekly pay, gross pay during period of appointment, etc based on                                                                                                             PAY RATE, and PAY CYCLE.                        > appt amt = PAY RATE x 26                          paid. Either: 1) person has an affiliated appt   12
                                     different object codes.                                                                                                                                                                                   OC 104,114,106 -> any pay cycle -> any pay      OC 115,118,119 -> any pay cycle -> any pay          but does not get paid by NYU, 2) Person on       OC 102,112,103,113 -> 96 pay term -> appt amt = PAY RATE x 6
                                                                                                                                                                                                                                               term -> appt amt = PAY RATE x work hours        term -> appt amt = PAY RATE                         an unpaid leave of absence, 3) appt is           OC 102,112,103,113 -> 97 pay term -> appt amt = PAY RATE x 7
                                                                                                                                                                                                                                               OC 116,107,117, 100, 110 -> M1 paycycle ->      OC 102,112,103,113 -> any pay cycle -> 01-          cancelled (ApptAmt=$1.00 AND the Appt            OC 102,112,103,113 -> 98 pay term -> appt amt = PAY RATE x 9
                                                                                                                                                                                                                                               any pay term -> appt amt = PAY RATE x 12        11 pay term -> appt amt = PAY RATE x PAY            Begin Date=Appt End Date)
                                                                                                                                                                                                                                                                                               TERM


EMPLOYMENT_VW    Fctly Bse Sal Amt   The annualized salary of the primary appointment. Although this is labeled Faculty base, this field   NUMBER         9,2 30,000                                      NYU_EDB_EMP      FCTLY_BSE_SAL_AMT   OC 104,114,106 -> any pay cycle/term -> base    OC 103 -> any pay cycle/term -> base salary         Does not include administrative stipend or       OC 102 -> any pay cycle -> 96 pay term -> base salary = PAY RATE
                                     is populated not only for code 102s, but 103s, 113s, 100s and 110s.                                                                                                                                       salary = PAY RATE x work hours x 52             = PAY RATE x 12                                     additional compensation for miscellaneous        x 12
                                                                                                                                                                                                                                               OC 116,107,117, 100,110 -> M1 pay cycle ->      OC 112,113,118 -> any pay cycle/term -> no          short-term assignments.                          OC 102 -> any pay cycle -> 97 pay term -> base salary =PAY RATE
                                                                                                                                                                                                                                               any pay term -> base salary = PAY RATE x 12     BASE SALARY                                                                                          x 14
                                                                                                                                                                                                                                               OC 100,110 -> B1 pay cycle -> any pay term ->   OC 119, 102 -> any pay cycle -> 92 pay term     -
                                                                                                                                                                                                                                               base salary = PAY RATE x 26                     > base salary = PAY RATE x 12



EMPLOYMENT_VW    Bldng Cd            Work Location of employee - Building Name                                                             VARCHAR2         5 726BW
EMPLOYMENT_VW    Room No             Work Location of employee - Room No                                                                   VARCHAR2         5 7FL
EMPLOYMENT_VW    Loa Bgn Dt          The date the leave of absence of the employee begins.                                                 DATE               01/01/01 12:00 AM                           NYU_EDB_EMP      LOA_BGN_DT
                                     10-character alphanumeric (maximum).
                                     Valid formats are:
                                     MMDDYYYY
                                     MM DD YYYY
                                     MM/DD/YYYY
                                     MM-DD-YYYY
                                     MM.DD.YYYY
EMPLOYMENT_VW    Loa Rtn Dt          The estimated or actual date the employee returns from leave.                                         DATE               01/01/01 12:00 AM                           ISI_EDB_BAS,     LOARETDT,
                                     10-character alphanumeric (maximum).                                                                                                                                 NYU_EDB_EMP      LOA_RTN_DT
                                     Valid formats are:
                                     MMDDYYYY
                                     MM DD YYYY
                                     MM/DD/YYYY
                                     MM-DD-YYYY
                                     MM.DD.YYYY
EMPLOYMENT_VW    Loa Srv Ind         Indicates whether the leave counts towards tenure and/or sabbatical, as applicable.                   VARCHAR2         1 Y                                           NYU_EDB_EMP      LOA_SRV_IND
                                     Optional.
                                     1-character alphanumeric.
                                     Valid codes: Y or N.
EMPLOYMENT_VW    Loa Pay Pct         The percent of base pay the employee receives while on leave.                                         DATE               0                                           NYU_EDB_EMP      LOA_PAY_PCT
                                     3-digit numeric.
                                     Formatted 999.
                                     Valid codes:
                                     000 - 100




                                                                                                                                                                                                                                                                                                                                                                                                                                    Page 23 of 28
                                                                                                                                                                                          07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View               Field                                              Description                                                  Data Type   Length Example                                           Source Table        Source Field                    Additional Info 1                                  Additional Info 2                                 Additional Info 3                                              Additional Info 4
EMPLOYMENT_VW    Loareasn            Indicates the reason for the leave of absence.                                                         VARCHAR2           2 SF - Sabbatical (fall semester)               ISI_EDB_BAS       LOAREASN            CL - Child care                                    IL - Illness/disability (non-faculty)                OA - Other (faculty: academic year)                PL - Personal (non-faculty)
                                                                                                                                                                                                                                                     DL - Long term disability                          IS - Illness/disability (faculty: spring semester)   OF - Other (faculty: fall semester)                PS - Personal (faculty: spring semester)
                                                                                                                                                                                                                                                     FC - FMLA leave (child care)                       MA - Military (faculty: academic year)               OL - Other (non-faculty)                           SA - Sabbatical (academic year)
                                                                                                                                                                                                                                                     FF - FMLA leave (medical - family)                 MF - Military (faculty: fall semester)               OS - Other (faculty: spring semester)              SF - Sabbatical (fall semester)
                                                                                                                                                                                                                                                     FS - FMLA leave (medical - self)                   ML - Military (non-faculty)                          PA - Personal (faculty: academic year)             SS - Sabbatical (spring semester)
                                                                                                                                                                                                                                                     IA - Illness/disability (faculty: academic year)   MS - Military (faculty: spring semester)             PF - Personal (faculty: fall semester)             UL - University requested leave
                                                                                                                                                                                                                                                     IF - Illness/disability (faculty: fall semester)


EMPLOYMENT_VW    Sepreasn            Indicates the reason for separation.                                                                   VARCHAR2           2 12 - Non-reappointment                        ISI_EDB_BAS       SEPREASN            01 - Terminated during probation                   11 - Temporary employment ended
                                                                                                                                                                                                                                                     02 - Termination                                   12 - Non-reappointment
                                                                                                                                                                                                                                                     03 - Death                                         13 - Canceled
                                                                                                                                                                                                                                                     04 - Retirement                                    14 - Other
                                                                                                                                                                                                                                                     05 - Illness disability                            15 - Quit without notice (during probation)
                                                                                                                                                                                                                                                     06 - Layoff                                        16 - Change to non-permanent
                                                                                                                                                                                                                                                     07 - Resigned during probation                     18 - Expired document
                                                                                                                                                                                                                                                     08 - Resigned                                      20 - Terminated retiree
                                                                                                                                                                                                                                                     09 - Quit without notice                           21 - Terminated spouse/dependent
                                                                                                                                                                                                                                                     10 - Transfer to Medical Center                    70 - System separation


EMPLOYMENT_VW    Seprtn Dt           Date the employee was separated.                                                                       DATE                  01/01/01 12:00 AM                            NYU_EDB_EMP       SEPRTN_DT
                                     10-character alphanumeric (maximum).
                                     Valid formats:
                                     MMDDCCYY
                                     MM DD CCYY
                                     MM/DD/CCYY
                                     MM-DD-CCYY
                                     MM.DD.CCYY
EMPLOYMENT_VW    Spclstat            Indicates the tenure status of faculty members.                                                        VARCHAR2           1 T - Tenured                                   ISI_EDB_BAS       SPCLSTAT
                                     1-character alphanumeric.
                                     Valid codes:
                                     Blank - No special status or not applicable
                                     E - Tenure-eligible
                                     N - Not eligible for tenure
                                     T - Tenured
                                     X-
EMPLOYMENT_VW    Tenr Stts Dt        The effective date of the tenure status of the faculty member.                                         DATE                 01/01/01 12:00 AM
EMPLOYMENT_VW    Job Fmly Cd         This code identifies the general functional responsibility of this job assignment.                     CHAR               1 A - Administrative services                   NYU_EDB_JOB       JOB_FMLY_CD         1 - Finance                                        A - Administrative services                          G - General administrative support                 Q - Admissions, registration, and financial aid
                                                                                                                                                                                                                                                     2 - Communications                                 B - Sergeant guards (for object code 107,            K - Communications                                 S - Survivors of retirees
                                                                                                                                                                                                                                                     3 - Institutional facilities                       117)                                                 L - Library, technical, and data processing (for   T - Animal, dental/medical, media lab technicians
                                                                                                                                                                                                                                                     4 - Administrative services                        C - Elevator starters (for object code 107,          object code 100, 110)                              X - Academic administrators not in plan
                                                                                                                                                                                                                                                     5 - Student affairs                                117)                                                 L - Comp, equip fab, general technical             Z - Student affairs
                                                                                                                                                                                                                                                     6 - Admissions, registration, and financial aid    D - Academic support (for object code 100,           support (for object code 104, 114)
                                                                                                                                                                                                                                                     7 - Library, technical, and data processing        110)                                                 N - Institutional facilities
                                                                                                                                                                                                                                                     8 - Academic support                               D - Cdl, dental equipment repair technicians
                                                                                                                                                                                                                                                                                                        (for object code 104, 114)
                                                                                                                                                                                                                                                                                                        F - Finance

EMPLOYMENT_VW    Emp Ctgy Cd         The employee category associated with this job assignment which identifies a grouping of similar       VARCHAR2           1 F - Faculty                                   NYU_EDB_JOB       EMP_CTGY_CD         A - Administrative and Professional                N - Student
                                     jobs for reporting purposes.                                                                                                                                                                                    D - Post-Doctoral Fellows                          R - Professional Researcher
                                                                                                                                                                                                                                                     F - Faculty                                        S - Clerical, Technical, and Service Staff
                                                                                                                                                                                                                                                     G - Unpaid appointments                            T - Casual employees
                                                                                                                                                                                                                                                     K - Graduate, Research, and Teaching               X - University Officers
                                                                                                                                                                                                                                                     Assistants                                         Z - Retired employees
                                                                                                                                                                                                                                                     M - Management, Directors and Academic
                                                                                                                                                                                                                                                     Administrators
EMPLOYMENT_VW    Orgid               Active employees are stored in the Active Org which is OrgID=blank; Retirees are in the RET org        VARCHAR2          13 <blank> or <RET>
                                     with OrgID=RET.
EMPLOYMENT_VW    Qtrno               Quarter Number - The field qtrno should be =0 in most queries but in the actual table in HRIS it can                         0
                                     also be a 4 (for tax purposes).
EMPLOYMENT_VW    Socsecno            Social Security Number of employee                                                                     INTEGER              111223333
EMPLOYMENT_VW    Addlssn             Not used.                                                                                              CHAR              10
EMPLOYMENT_VW    Sex                 Th sex of the employee.                                                                                CHAR               1 M                                             ISI_EDB_PER       SEX
                                     Valid codes:
                                     F - Female
                                     M - Male
EMPLOYMENT_VW    Birthdt             Date of birth of the employee.                                                                         DATE                  03/15/80 12:00 AM                            ISI_EDB_PER       BIRTHDT
                                     Required.
                                     10-character alphanumeric (maximum).
                                     Valid formats:
                                     MMDDYYYY
                                     MM DD YYYY
                                     MM/DD/YYYY
                                     MM-DD-YYYY
                                     MM.DD.YYYY

EMPLOYMENT_VW    Ethnicty            No longer used (see ETHNICITY_RACE).                                                                   CHAR               1 A - Native American/Amerind/Alaskan native    ISI_EDB_PER       ETHNICTY                                                               If the CNTRY code of the Organization Table                                                             Blank - Not indicated
                                                                                                                                                                                                                                                                                                        entry for this ORG is CAN, the ETHNICITY                                                                A - Native American/Amerind/Alaskan native
                                                                                                                                                                                                                                                                                                        must be 1, 2, 3, 4, or blank. Otherwise, it                                                             B - Black/African-American
                                                                                                                                                                                                                                                                                                        must be A, B, C, R, S, or blank.                                                                        C - Caucasian/White
                                                                                                                                                                                                                                                                                                                                                                                                                R - Asian/Pacific islander
                                                                                                                                                                                                                                                                                                                                                                                                                S - Hispanic/Latino




                                                                                                                                                                                                                                                                                                                                                                                                                                                  Page 24 of 28
                                                                                                                                                                                      07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View              Field                                               Description                                                  Data Type   Length Example                                       Source Table        Source Field                   Additional Info 1                                Additional Info 2               Additional Info 3                              Additional Info 4
EMPLOYMENT_VW    Ctznvisa           Indicates U.S. citizenship, immigrant status, or type of visa held by the employee.                     CHAR               2 US                                        ISI_EDB_PER       CTZNVISA            A1 - Diplomatic and government officials (high                                                                       J1 - Exchange visitor
                                                                                                                                                                                                                                                 level)                                             G1/2/3/4 - Representatives to international                       J2 - Spouse or child of an exchange visitor
                                                                                                                                                                                                                                                 A2 - Diplomatic and government officials (lesser   organizations and their families                                  O1 - Extraordinary ability
                                                                                                                                                                                                                                                 rank)                                              H1 - Temporary worker - professional or                           O2 - Extraordinary support
                                                                                                                                                                                                                                                 E1 - Treaty trader                                 skilled                                                           TN - Canadian/Mexican national
                                                                                                                                                                                                                                                 E2 - Treaty investor                               H2 - Temporary worker - general labor                             TR - Temporary resident
                                                                                                                                                                                                                                                 EA - Employment Authorization card                 H3 - Temporary worker - trainee                                   US - U.S. citizen
                                                                                                                                                                                                                                                 F1 - Student                                       IM - Immigrant


EMPLOYMENT_VW    Ctzncnty           Current country of citizenship (if other than U.S.).                                                    CHAR              3                                            ISI_EDB_PER       CTZNCNTY
                                    Conditionally required.
                                    2-character alphanumeric.
                                    Valid codes are assigned by the federal government.
                                    Use the table look-up feature to find current values and translations.
EMPLOYMENT_VW    Visaexdt           The expiration date of the visa for the employee, if any.                                               DATE                  01/01/01 12:00 AM                        ISI_EDB_PER       VISAEXDT
                                    Conditionally required.
                                    Date.
                                    Valid formats:
                                    MMDDYYYY
                                    MM DD YYYY
                                    MM/DD/YYYY
                                    MM-DD-YYYY
                                    MM.DD.YYYY

EMPLOYMENT_VW    Educlvl            The highest level of education completed or degree achieved by the employee.                            CHAR              2 MA - Masters degree                        ISI_EDB_PER       EDUCLVL             Blank - Not indicated                              HS - High school
                                                                                                                                                                                                                                                 AA - Associate degree                              JD - Juris doctor
                                                                                                                                                                                                                                                 AS - Associate degree                              LD - Doctor of law
                                                                                                                                                                                                                                                 BA - Bachelors degree                              LM - Master of laws
                                                                                                                                                                                                                                                 BS - Bachelors degree                              MA - Masters degree
                                                                                                                                                                                                                                                 CO - Some college                                  MB - Master of business administration
                                                                                                                                                                                                                                                 DD - Doctor of dentistry                           MD - Doctor of medicine
                                                                                                                                                                                                                                                 DR - Other doctorate (Ed.D.)                       MS - Masters degree
                                                                                                                                                                                                                                                 EN - Engineering degree                            NI - Not indicated
                                                                                                                                                                                                                                                 GS - Less than HS diploma                          PH - Ph.D.
                                                                                                                                                                                                                                                                                                    TC - Trade certificate

EMPLOYMENT_VW    Educlvyr           The year the employee achieved the education level specified in the EDUC LEVEL field.                   DATE                  1992                                     ISI_EDB_PER       EDUCLVYR
                                    Optional.
                                    4-digit numeric.
                                    Valid format: YYYY
EMPLOYMENT_VW    Milstat            The military status reported by the employee.                                                           CHAR              1 A - Active reserve                         ISI_EDB_PER       MILSTAT
                                    Blank - Not indicated
                                    A - Active reserve
                                    D - Special disabled veteran
                                    N - Inactive reserve
                                    O - Veteran
                                    R - Retired
                                    S - Special disabled Vietnam veteran
                                    V - Vietnam era veteran

EMPLOYMENT_VW    Refsrc             Indicates how the employee was referred for employment.                                                 CHAR              1 P                                          ISI_EDB_PER       REFSRC
                                    The first:
                                    Valid codes: D (dept hire) or P (personnel hire)
                                    The second:
                                    Indicates specific source through which the employee learned of the opening.
                                    Valid codes: listed on the Referral Source Table.
EMPLOYMENT_VW    Alienrno           Not used.                                                                                               CHAR             10
EMPLOYMENT_VW    Langprf            Not used.                                                                                               CHAR              2
EMPLOYMENT_VW    Curstr             Current address of employee - street line 1                                                             CHAR             30
EMPLOYMENT_VW    Curstr2            Not used.                                                                                               CHAR             30
EMPLOYMENT_VW    Curcity            Current address of employee - city                                                                      CHAR             30
EMPLOYMENT_VW    Curcnty            Not used.                                                                                               CHAR             20
EMPLOYMENT_VW    Curstate           Current address of employee - state                                                                     CHAR              2
EMPLOYMENT_VW    Curcntry           Not used.                                                                                               CHAR              3
EMPLOYMENT_VW    Curzip             Current address of employee - postal code                                                               CHAR             10
EMPLOYMENT_VW    Hmphone            Home area code and telephone number for employee.                                                       NUMBER           11                                            ISI_EDB_PER       HMPHONE
                                    Optional.
                                    12-character alphanumeric (maximum).
                                    Valid formats:
                                    9999999999
                                    999/999-9999
EMPLOYMENT_VW    Wkphone            Area code and telephone number at work for employee.                                                    NUMBER           11                                            ISI_EDB_PER       WKPHONE
                                    Optional.
                                    12-character alphanumeric (maximum).
                                    Valid formats:
                                    9999999999
                                    999/999-9999
EMPLOYMENT_VW    Wrkdept            Work department of employee.                                                                            CHAR              8
EMPLOYMENT_VW    Wrkext             Not used.                                                                                               CHAR              4
EMPLOYMENT_VW    Badgeid            Not used.                                                                                               CHAR              6
EMPLOYMENT_VW    Altaddfl           Alternate address field indicator. A value of Y indicates the employee has submitted an alternate       CHAR              1
                                    address to Payroll for W-2 mailing.
EMPLOYMENT_VW    Emrgcont           Emergency contact person for employee.                                                                  CHAR             30
EMPLOYMENT_VW    Contrltn           Emergency contact person for employee - relationship.                                                   CHAR              8
EMPLOYMENT_VW    Emrgphon           Emergency contact person for employee - contact number.                                                 NUMBER           11
EMPLOYMENT_VW    Bloodtyp           Not used.                                                                                               CHAR              6
EMPLOYMENT_VW    Fmlaenti           Not used.                                                                                               NUMBER          5,2 0
EMPLOYMENT_VW    Fmlabegd           Not used.                                                                                               DATE                01/01/01 12:00 AM
EMPLOYMENT_VW    I9Status           I-9 employment eligibility indicator. A value of Y indicates the employee has an I-9 on file with the   CHAR              1
                                    University.



                                                                                                                                                                                                                                                                                                                                                                                                         Page 25 of 28
                                                                                                                                                                                       07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View              Field                                              Description                                               Data Type   Length Example                                           Source Table        Source Field                  Additional Info 1                              Additional Info 2                               Additional Info 3                                      Additional Info 4
EMPLOYMENT_VW    I9Statdt           The expiration date of the employment eligibility (I-9) status of the employee.                     DATE                 01/01/01 12:00 AM
EMPLOYMENT_VW    Unionid            The union code of the employee identifying the bargaining unit of the employee.                     CHAR               6
EMPLOYMENT_VW    Lstindt                                                                                                                DATE
EMPLOYMENT_VW    Lstinamt           Not used.                                                                                           NUMBER          11,4
EMPLOYMENT_VW    Lstintyp                                                                                                               CHAR               1
EMPLOYMENT_VW    Perfrtng           The performance rating of the employee related to their primary appointment.                        DATE
EMPLOYMENT_VW    Prsupv             Not used.                                                                                           CHAR             30
EMPLOYMENT_VW    Minrcd             Indicates whether the database record for employee contains sufficient data for payroll processing. VARCHAR2          1                                                 ISI_EDB_BAS      MINRCD              The following data must be present to satisfy   Active Job Assignment - all job assignment                                                  Valid codes:
                                                                                                                                                                                                                                                 minimum record requirements:                    segments present must have the following                                                    NO - Minimum data is not present.
                                                                                                                                                                                                                                                 Employee ID                                     fields present and there must be at least one                                               OK - Minimum data is present.
                                                                                                                                                                                                                                                 Organization ID                                 job assignment segment.
                                                                                                                                                                                                                                                 Employee Name
                                                                                                                                                                                                                                                 Employment Status
                                                                                                                                                                                                                                                 Active Job Assignment
                                                                                                                                                                                                                                                 Job Class Number
                                                                                                                                                                                                                                                 Rate Code
                                                                                                                                                                                                                                                 Pay Rate
                                                                                                                                                                                                                                                 Job Pay Cycle
                                                                                                                                                                                                                                                 Time Report Code

EMPLOYMENT_VW    Namesufx           The suffix that may follow the name of the employee, such as Esq., PhD, III, Jr.                    VARCHAR2           4                                                ISI_EDB_BAS      NAMESUFX
                                    Optional.
                                    4-character alphanumeric.
EMPLOYMENT_VW    Nameprfx           The prefix for the name of the employee; such as Mr., Mrs., or Dr.                                  VARCHAR2           4                                                ISI_EDB_BAS      NAMEPRFX
                                    Optional.
                                    4-character alphanumeric.
EMPLOYMENT_VW    Phonkey                                                                                                                VARCHAR2           5
EMPLOYMENT_VW    Spclstdt           The date when the employee received or is expected to receive tenure.                               DATE                                                                ISI_EDB_BAS,     SPCLSTDT,
                                    Date.                                                                                                                                                                   NYU_EDB_EMP      TENR_STTS_DT
                                    Valid formats:
                                    MMDDCCYY
                                    MM DD CCYY
                                    MM/DD/CCYY
                                    MM-DD-CCYY
                                    MM.DD.CCYY
EMPLOYMENT_VW    Paystat                                                                                                                VARCHAR2           1
EMPLOYMENT_VW    Rehire             Rehire eligible indicator.                                                                          VARCHAR2           1
EMPLOYMENT_VW    Senrtydt           The date from which the years of service for the employee are calculated.                           DATE                   01/01/01 12:00 AM                            ISI_EDB_BAS      SENRTYDT
                                    10-character alphanumeric (maximum).
                                    Valid formats:
                                    MMDDCCYY
                                    MM DD CCYY
                                    MM/DD/CCYY
                                    MM-DD-CCYY
                                    MM.DD.CCYY
EMPLOYMENT_VW    Partfull           Indicates whether the employee is full time or part time.                                           VARCHAR2           1 F
                                    Valid codes:
                                    F - Full
                                    P - Part
EMPLOYMENT_VW    Empltype                                                                                                               VARCHAR2          1
EMPLOYMENT_VW    Fromxorg           If the employee has been transferred to the RET (retiree) organization, this field indicates RET.   VARCHAR2         13                                                 ISI_EDB_BAS      FROMXORG

EMPLOYMENT_VW    Fromxid            If the ID of the employee has been changed, this field indicates the prior ID.                      VARCHAR2           9                                                ISI_EDB_BAS      FROMXID
EMPLOYMENT_VW    Toxid              Displays new ID if ID has been changed or when employee transfers between organizations.            VARCHAR2           9                                                ISI_EDB_BAS      TOXID

EMPLOYMENT_VW    Lvaccdt                                                                                                                DATE                   01/01/01 12:00 AM
EMPLOYMENT_VW    Lvaccsch                                                                                                               VARCHAR2           2
EMPLOYMENT_VW    Benbasal           Benefits base salary                                                                                NUMBER          11,2
EMPLOYMENT_VW    Annbasrt           Annualized base salary                                                                              NUMBER          11,2
EMPLOYMENT_VW    Orighrdt           This field preserves the original hire date of the employee in case of a break in employment and    DATE                                                                ISI_EDB_BAS      ORIGHRDT
                                    later reemployment. (Also called floor date.)
EMPLOYMENT_VW    Hrdt401K                                                                                                               DATE                 01/01/01 12:00 AM
EMPLOYMENT_VW    Lstactn1           The most recent primary personnel action processed for the employee.                                VARCHAR2           2 01 - Initial employment                        ISI_EDB_BAS      LSTACTN1            01 - Initial employment                         14 - Rehire                                     40 - Multiple actions                       71 - Deleted record (display only)
                                                                                                                                                             06 - Promotion                                                                      02 - Leave of absence with pay                  21 - Additional appointment                     41 - Extension of appointment               72 - Organization change (display only)
                                                                                                                                                                                                                                                 03 - Leave of absence without pay               22 - Revision of title                          42 - Extension of additional compensation   73 - Employee ID change (display only)
                                                                                                                                                                                                                                                 04 - Return from leave of absence               23 - Additional compensation                    43 - Extension of leave of absence
                                                                                                                                                                                                                                                 05 - Separation                                 24 - Reappointment                              44 - Change of leave type
                                                                                                                                                                                                                                                 06 - Promotion                                  25 - Change to account distribution             50 - Priority change
                                                                                                                                                                                                                                                 07 - Job reclassification                       26 - Reinstatement
                                                                                                                                                                                                                                                 08 - Demotion                                   27 - Salary change
                                                                                                                                                                                                                                                 10 - Transfer                                   28 - Union increase
                                                                                                                                                                                                                                                 11 - Other change                               29 - In-grade increase
                                                                                                                                                                                                                                                 12 - Data correction                            30 - Longevity increase

EMPLOYMENT_VW    Lstactn2           The most recent secondary personnel action processed for the employee.                              VARCHAR2           2
EMPLOYMENT_VW    Lstactn3           The most recent tertiary personnel action processed for the employee.                               VARCHAR2           2
EMPLOYMENT_VW    Lstactdt           The effective date of the most recent personnel action.                                             DATE                                                                ISI_EDB_BAS      LSTACTDT
EMPLOYMENT_VW    Prevdept                                                                                                               VARCHAR2           8
EMPLOYMENT_VW    Nxtprdte                                                                                                               DATE
EMPLOYMENT_VW    Prbstat            Not used.                                                                                           CHAR               2
EMPLOYMENT_VW    Prbbgndt           Not used.                                                                                           DATE
EMPLOYMENT_VW    Prbenddt           Not used.                                                                                           DATE
EMPLOYMENT_VW    Prblact            Not used.                                                                                           CHAR               2
EMPLOYMENT_VW    Prblacdt           Not used.                                                                                           DATE
EMPLOYMENT_VW    Prcommnt           Not used.                                                                                           CHAR             30
EMPLOYMENT_VW    Aastreet           Alternate address - street field 1                                                                  CHAR             30
EMPLOYMENT_VW    Aastr2             Alternate address - street field 2                                                                  CHAR             30
EMPLOYMENT_VW    Aacity             Alternate address - city                                                                            CHAR             30
EMPLOYMENT_VW    Aacntry            Alternate address - country                                                                         CHAR              3



                                                                                                                                                                                                                                                                                                                                                                                                                                 Page 26 of 28
                                                                                                                                                                                     07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View              Field                                                 Description                                           Data Type    Length Example                                         Source Table        Source Field    Additional Info 1   Additional Info 2   Additional Info 3   Additional Info 4
EMPLOYMENT_VW    Nyu Aastr3           Alternate address - street field 3                                                               CHAR               30
EMPLOYMENT_VW    Nyu Province         Alternate address - province                                                                     CHAR               30
EMPLOYMENT_VW    Nyu Postal Cd        Alternate address - postal code                                                                  CHAR               30
EMPLOYMENT_VW    Nyu Phone No         Alternate address - phone number                                                                 CHAR               30
EMPLOYMENT_VW    Nyu Comment1 Txt     Not used.                                                                                        CHAR               30
EMPLOYMENT_VW    Nyu Comment2 Txt     Not used.                                                                                        CHAR               30
EMPLOYMENT_VW    Wrk Hrs              The standard work hours for the employee in a normal work week. This number is used to           NUMBER            4,2 35                                           NYU_EDB_EMP      WRK_HRS
                                      determine the correct accrual rate for vacation and sick leave.
                                      4-digit numeric.
                                      Formatted 99.99.
                                      Valid values: 00.00 - 40.00.
EMPLOYMENT_VW    Rfrl Sub Ctgy Cd     Job referral code identifying how the employee was referred to the University.                   VARCHAR2           2
EMPLOYMENT_VW    Cr Of Nme Addr                                                                                                        VARCHAR2          30
EMPLOYMENT_VW    Site Cd              The primary work location site of the employee.                                                  VARCHAR2           2
EMPLOYMENT_VW    Chk Lctn Cd          Check location code                                                                              VARCHAR2           2 01
EMPLOYMENT_VW    Smstrs Int Srv No    The number of semesters of leave to be counted as interruption to years of service.              INTEGER              0                                             NYU_EDB_EMP      SMSTRS_INT_SRV_NO
                                      2-digit numeric.
EMPLOYMENT_VW    Rtrmnt Dt            The effective date of retirement of the employee. Maintained by Benefits only.                   DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP      RTRMNT_DT
                                      10-character alphanumeric (maximum).
                                      Valid formats:
                                      MMDDCCYY
                                      MM DD CCYY
                                      MM/DD/CCYY
                                      MM-DD-CCYY
                                      MM.DD.CCYY
EMPLOYMENT_VW    Instrctr Dt          The date when the employee achieved the rank of Instructor.                                      DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP      INSTRCTR_DT
                                      Optional.
                                      5-character alphanumeric (maximum).
                                      Valid formats are:
                                      MMYY
                                      MM/YY
EMPLOYMENT_VW    Asstnt Dt            The date when the employee achieved the rank of Assistant Professor.                             DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP      ASSTNT_DT
                                      Optional.
                                      5-character alphanumeric (maximum).
                                      Valid formats are:
                                      MMYY
                                      MM/YY
EMPLOYMENT_VW    Asscte Dt            The date when the employee achieved the rank of Associate Professor.                             DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP      ASSCTE_DT
                                      Optional.
                                      5-character alphanumeric (maximum).
                                      Valid formats are:
                                      MMYY
                                      MM/YY
EMPLOYMENT_VW    Prfssr Dt            The date when the employee achieved the rank of Professor.                                       DATE                   01/01/01 12:00 AM                           NYU_EDB_EMP      PRFSSR_DT
                                      Optional.
                                      5-character alphanumeric (maximum).
                                      Valid formats are:
                                      MMYY
                                      MM/YY
EMPLOYMENT_VW    Vctn Due Hrs         The vacation hours due at time of separation.                                                    NUMBER           5,2 0                                             NYU_EDB_EMP      VCTN_DUE_HRS
                                      5-digit numeric.
                                      Valid format: 999.99.
EMPLOYMENT_VW    Svrnc Due Pay Amt    The dollar amount due as severance pay at the time of separation.                                NUMBER           9,2 0                                             NYU_EDB_EMP      SVRNC_DUE_PAY_AMT
                                      9-digit numeric.
                                      Valid format: 9999999.99
EMPLOYMENT_VW    Sub Actn Cd 1        The subaction code entered when the record of the employee was last updated.                     VARCHAR2           3                                               NYU_EDB_EMP      SUB_ACTN_CD_1
EMPLOYMENT_VW    Job 1 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 1 of the employee is   VARCHAR2           2
                                      paid.
EMPLOYMENT_VW    Job 2 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 2 of the employee is   VARCHAR2           2
                                      paid.
EMPLOYMENT_VW    Job 3 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 3 of the employee is   VARCHAR2           2
                                      paid.
EMPLOYMENT_VW    Job 4 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 4 of the employee is   VARCHAR2           2
                                      paid.
EMPLOYMENT_VW    Job 5 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 5 of the employee is   VARCHAR2           2
                                      paid.
EMPLOYMENT_VW    Job 6 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 6 of the employee is   VARCHAR2           2
                                      paid.
EMPLOYMENT_VW    Job 7 Pay Cycle Cd   The pay cycle (eg. monthly, semi-monthly, bi-weekly, weekly) on which job 7 of the employee is   VARCHAR2           2
                                      paid.
EMPLOYMENT_VW    Tx Treaty Frm Id                                                                                                         VARCHAR2        1
EMPLOYMENT_VW    Tx Treaty Lmt Amt    Indicates the tax treaty compensation limit (for non-resident aliens).                              NUMBER        7,2
EMPLOYMENT_VW    Tx Treaty Lmt Dt     Indicates the expiration date of the tax treaty compensation limitation of the employee.            DATE
EMPLOYMENT_VW    Email Addr           Identifies the university email address (if activated) of the employee.                             VARCHAR2       30
EMPLOYMENT_VW    Fax Phone No         Indicates the primary office fax number of the employee.                                            VARCHAR2       10
EMPLOYMENT_VW    Netid                Idientifies the university NetId of the employee.                                                   VARCHAR2       16
EMPLOYMENT_VW    Racfid               Not used.                                                                                           VARCHAR2        8
EMPLOYMENT_VW    Pin                  Not used.                                                                                           VARCHAR2        8
EMPLOYMENT_VW    Service Award No     Indicates the service year milestone the employee has achieved.                                     DATE
EMPLOYMENT_VW    Oath Ind             Identifies whether an instructional faculty member has signed and filed the NY State teaching oath. VARCHAR2        1

EMPLOYMENT_VW    Emeritus Dt          Identifies the effective date of status as Professor Emeritus of a faculty member.               DATE
EMPLOYMENT_VW    Prvsrv For Tnr Ind   Indicates whether previous service has been a consideration in tenure decisions.                 VARCHAR2           1 Y - Qualifying service                        NYU_EDB_EMP      PRVSRV_FOR_TNR_IND
                                      1-position alpha.
                                      Values: N - No qualifying service
                                      Y - Qualifying service
                                      V - Qualifying service not confirmed (verify)




                                                                                                                                                                                                                                                                                                                    Page 27 of 28
                                                                                                                                                                                                07778499-2836-4a87-ab41-2bfa0087ad4a.xls - View Details


          View              Field                                                 Description                                                 Data Type   Length Example                                               Source Table       Source Field                  Additional Info 1                              Additional Info 2            Additional Info 3                              Additional Info 4
EMPLOYMENT_VW    Payrate            Identifies the job rate of pay per pay cycle of the employee.                                            NUMBER          11,4 2,500.00
EMPLOYMENT_VW    Ratecode           Indicates if PAY RATE is hourly or payment for the pay period.                                           VARCHAR2           1 P - Salary for pay period                          ISI_EDB_JOB      RATECODE
                                    1-character alphanumeric.
                                    Valid codes:
                                    H - Hourly rate
                                    P - Salary for pay period
EMPLOYMENT_VW    Reteffdt           The effective date of the new rate.                                                                      DATE                                                                    ISI_EDB_PAY      RETEFFDT
                                    10-character alphanumeric (maximum).
                                    Valid formats:
                                    MMDDCCYY
                                    MM DD CCYY
                                    MM/DD/CCYY
                                    MM-DD-CCYY
                                    MM.DD.CCYY
EMPLOYMENT_VW    Pctfull                                                                                                                     NUMBER           5,2 100
EMPLOYMENT_VW    Payterm            Identifies the length of the job assignment and the period of payment.                                   VARCHAR2             02 - 10-month assignment paid over 12 months       ISI_EDB_JOB      PAYTERM             00 - 10-month assignment paid over 10 months    90 - 9-month assignment paid over 10                          97 - 4 1/2 month assignment paid over 7 months (spring)
                                                                                                                                                                                                                                                          01-09 - specific number of payments for temp.   months                                                        98 - 9-month assignment paid over 8 months
                                                                                                                                                                                                                                                          appt.                                           92 - 9-month assignment paid over 12
                                                                                                                                                                                                                                                          02 - 10-month assignment paid over 12 months    months
                                                                                                                                                                                                                                                          12 - 11-month assignment paid over 12 months    94 - 4 1/2 month assignment paid over 4
                                                                                                                                                                                                                                                          22 - 12-month assignment paid over 12 months    months (fall, spring)
                                                                                                                                                                                                                                                                                                          96 - 4 1/2 month assignment paid over 6
                                                                                                                                                                                                                                                                                                          months (fall)



EMPLOYMENT_VW    Paycycle           Identifies the frequency of payment for the job assignment.                                              VARCHAR2               B1, B2 - Biweekly                                ISI_EDB_JOB      PAYCYCLE                                                                                                                          B1, B2 - Biweekly
                                                                                                                                                                    M1, M2 - Monthly                                                                                                                                                                                    M1, M2 - Monthly
                                                                                                                                                                    W1, W2 - Weekly                                                                                                                                                                                     W1, W2 - Weekly
EMPLOYMENT_VW    Timecode           The method of time reporting required for this job assignment, and whether this job is listed on         VARCHAR2               P - Positive; listed                                                                                                                                                                                Hourly employees:
                                    Time Reports.                                                                                                                   E - Exception; not listed                                                                                                                                                                           N - Positive; not listed
                                                                                                                                                                                                                                                                                                                                                                        P - Positive; listed
                                                                                                                                                                                                                                                                                                                                                                        Salaried employees:
                                                                                                                                                                                                                                                                                                                                                                        E - Exception; not listed
                                                                                                                                                                                                                                                                                                                                                                        L - Exception by salary; listed
                                                                                                                                                                                                                                                                                                                                                                        T - Exception by time; listed
                                                                                                                                                                                                                                                                                                                                                                        Any employee:
                                                                                                                                                                                                                                                                                                                                                                        W - Job without salary; not listed

EMPLOYMENT_VW    Req To Rcrt        Request to Recruit number.                                                                               CHAR               6
EMPLOYMENT_VW    Job Eval No        Job evaluation code.                                                                                     CHAR               9
EMPLOYMENT_VW    Job Descr Txt      Job description code.                                                                                    CHAR              14
EMPLOYMENT_VW    Crse Ttl           Identifies the course section number taught by the instructor for this job (not required).               CHAR              30
EMPLOYMENT_VW    Cntct Hrs          Identifies the contact hours associated with the course taught by the instructor for this jo (not        NUMBER           6,2
                                    required).
EMPLOYMENT_VW    Cntct Typ Cd       A code available for school use to further identify the affiliation with a course (not required) of an   CHAR               1
                                    instructor.
EMPLOYMENT_VW    Job Bse Sal Amt                                                                                                             NUMBER           9,2
EMPLOYMENT_VW    Job Rate Cd        The rate code associated with this job assignment identifying if this is a salaried or hourly job.       CHAR               1

EMPLOYMENT_VW    Job Stamp          A unique timestamp per job in the database.                                                              VARCHAR2          26
EMPLOYMENT_VW    Job Acct Tot Amt   The total amount to be paid for all account for the specified job per pay cycle.                         NUMBER           9,3 2,500.00
EMPLOYMENT_VW    Longevity Cd       A code identifying the longevity tier achieved (for bargaining unit eligible jobs).                      CHAR              10
EMPLOYMENT_VW    Hrsbal01                                                                                                                    NUMBER           9,2
EMPLOYMENT_VW    Hrsbal02                                                                                                                    NUMBER           9,2
EMPLOYMENT_VW    Hispanic Ind       A Y/N flag identify whether the employee has identified themselves to be of hispanic origin.             CHAR               1

EMPLOYMENT_VW    Race1 Ind          A code identifying the identified ethnicity of the employee.                                             CHAR               1
EMPLOYMENT_VW    Race2 Ind          See RACE1_IND (employee may identify multiple ethnicities).                                              CHAR               1
EMPLOYMENT_VW    Race3 Ind          See RACE1_IND (employee may identify multiple ethnicities).                                              CHAR               1
EMPLOYMENT_VW    Race4 Ind          See RACE1_IND (employee may identify multiple ethnicities).                                              CHAR               1
EMPLOYMENT_VW    Race5 Ind          See RACE1_IND (employee may identify multiple ethnicities).                                              CHAR               1
EMPLOYMENT_VW    Race6 Ind          Not used.                                                                                                CHAR               1
EMPLOYMENT_VW    Race7 Ind          Not used.                                                                                                CHAR               1
EMPLOYMENT_VW    Race8 Ind          Not used.                                                                                                CHAR               1
EMPLOYMENT_VW    Race9 Ind          Not used.                                                                                                CHAR               1
EMPLOYMENT_VW    Race10 Ind         Not used.                                                                                                CHAR               1
EMPLOYMENT_VW    Mobile Device No   Cell phone number for employee                                                                           VARCHAR2          10
EMPLOYMENT_VW    Statusdt           The effective date of the Employment Status (see Emplstat) of an employee.                               DATE
EMPLOYMENT_VW    Lstpypdt           Last pay date the employee was paid (from any job).                                                      DATE                 09/30/08 12:00 AM
EMPLOYMENT_VW    Hrsbal45                                                                                                                    NUMBER           9,2
EMPLOYMENT_VW    Bldng Nm           Work Location of Employee -Building Name                                                                 CHAR              30
EMPLOYMENT_VW    Bldng Addr         Work Location of Employee - Address                                                                      CHAR              30
EMPLOYMENT_VW    Bldng Cty          Work Location of Employee - City                                                                         CHAR              30
EMPLOYMENT_VW    Bldng St           Work Location of Employee - State                                                                        CHAR               2
EMPLOYMENT_VW    Bldng Zp           Work Location of Employee - Postal Code                                                                  CHAR              10
EMPLOYMENT_VW    Unit Name          Hierarchy is Unit -> Dvision -> Department                                                               VARCHAR2          30 DIVISION OF LIBRARIES
EMPLOYMENT_VW    Div Name           Hierarchy is Unit -> Division -> Department                                                              VARCHAR2          30 DIVISION OF LIBRARIES
EMPLOYMENT_VW    Hr Rep Name        The name of the HR Officer (primary job) of an employee.                                                 VARCHAR2          30
EMPLOYMENT_VW    Hr Rep Netid       The university NetID of the HR Officer (primary job) of the employee.                                    VARCHAR2          16
EMPLOYMENT_VW    Vol Invol Ind      Voluntary/Involuntary separation indicator.                                                              CHAR               1
EMPLOYMENT_VW    Ui Challenge Ind   Unemployment Insurance challenge indicator.                                                              CHAR               1




                                                                                                                                                                                                                                                                                                                                                                                                             Page 28 of 28

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:9/7/2012
language:Catalan
pages:28