Report ID | Title | Description | Columns Included | Records Included | Developer | Requestor | Comments | Shared with |
---|---|---|---|---|---|---|---|---|
CU_BAR_HR_00001 | Position Status Details - BCTC | This report list you all the Positions in CUNYfirst with Incumbent History. | Position Number, Budget Line Numer, Heacount Status, PayServ Posn Number, Effective Date, Status, Reason, Action Date, Position Statu, Status Date, Key Position, Business Unit, Manager Level, Job Code, Job Code Descr, Reg/Temp, Full/Part Time, Regular Shift, Union Code, Title, Short Title, Reg Region, Department, Department Descr, Company, Location, Reports To, Dot-Line, EmplID, Empl Rcd, Pay Status, HR Status, Last Update Date Time, Updated By, Name | PS_POSITION_DATA, PS_JOB, PS_CU_POSITON_JR, PS_JOBCODE_TBL, PS_DEPT_TBL, PS_NAMES, | Ravi Swarna | College HR and College Budget Office | New Report | Christian Keck, Mary Rivers |
CU_BAR_HR_00002 | Direct Reports List for a given Manager | This report list the employees who are reporting to the given Manager. | Employee ID, Employee Name, Position Name and Full/Part Time | PS_JOB PS_PERSON_NAME | Ravi Swarna | College HR and College Budget Office | New Report | Christian Keck, Mary Rivers, Joseph Marte |
CU_BAR_HR_00003 | Employee Data for Online Directory | This report list the employees to prepare online directory for Campus | First Name, Middle Name, Last Name, Employee ID, HR Status, Full/Part Time, Job Indicator, Empl_RCD, Job Code, Job Code Descr, Labor Agreement, Union Position, Union Code, Union Code Description, Department ID, Department Description, Buiness Email, Preferred Phone Number, Location and Location Description. | PS_JOB, PS_PERSON_NAME, PS_DEPT_TBL, PS_EMAIL_ADDRESSES, PS_PERSONAL_PHONE, PS_PERSONAL_DATA, PS_LOCATION_TBL, PS_JOBCODE_TBL, and PS_UNION_TBL
| Ravi Swarna | Patrick Ankerman | New Report | Christian Keck,Joseph Marte, and Patrick Ackerman. |
CU_BAR_HR_00003_1 | Employee Data for Online Directory | This report list the employees to prepare online directory for Campus | First Name, Middle Name, Last Name, Employee ID, HR Status, Full/Part Time, Job Indicator, Empl_RCD, Job Code, Job Code Descr, Labor Agreement, Union Position, Union Code, Union Code Description, Department ID, Department Description, Buiness Email, Preferred Phone Number, Address 1, Address 2, City, County, State, Postal, Location and Location Description. | PS_JOB, PS_PERSON_NAME, PS_DEPT_TBL, PS_EMAIL_ADDRESSES, PS_PERSONAL_PHONE, PS_PERSONAL_DATA, PS_LOCATION_TBL, PS_JOBCODE_TBL, and PS_UNION_TBL | Ravi Swarna | Patrick Ankerman | New Report | Christian Keck,Joseph Marte, and Patrick Ackerman. |
CU_BAR_HR_00003_2 | Employee Data for online Directory | This report list the employees to prepare online directory for Campus | First Name, Middle Name, Last Name, Employee ID, HR Status, Full/Part Time, Job Indicator, Empl_RCD, Job Code, Job Code Description, Labor Agreement, Department ID, Department Description, Location, Location Description, Effective Date, Effective Sequence | PS_JOB, PS_PERSON_NAME, PS_DEPT_TBL, PS_PERSONAL_DATA, PS_JOBCODE_TBL, PS_LOCATION_TBL | Ravi Swarna | Patrick Ackerman | New Report | Christian Keck, Joseph Marte, and Patrick Ankerman. |
CU_BAR_HR_00003_3 | Employee Date for Mailing | This report lists employees for mailing via AD | EMPLID, First Name, Middle, Last Name, Job Code, Job Indicator, Full/Part Time, Labor Agreement, DeptID, Dept Description, Location | PS_JOB, PS_PERSON_NAME, PS_DEPT_TBL, PS_PERSONAL_DATA, PS_JOBCODE_TBL, PS_LOCATION_TBL | Patrick Ackerman | Modified Report | Dixon Berry | |
CU_BAR_HR_00004 | Hiring Manager List | This report list the active Hiring Manager | Department ID, Effective Date, Department Description, Manager Id, Manager Position, Manager Name | PS_DEPT_TBL, PS_EMPLOYEES | Ravi Swarna | Katharine Cobb and Monique George | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00005 | TAM Job Posting List | This report list all the Job Opening ID's with the Status and assigned Postion numbers | Job Opening ID, Template ID, Job Type, Referral Program ID, Originator ID, Manager ID, Recruiter ID, Recruiter Name, Selecitng Official, Created Date, Close Date, Status Code, Status Code description. Status Reason, Status Reason description, Status Date, Openings to Fill, Available Openings, Tartget Openings, Hot Job, Business Unit, Department SetID, Department ID, Company, Job Code, Position Number, Location Code, Recruiting Area, Posting Title, Start Date, Works Council ID, Encumbrance date Indicator, Projected Fill Date, Date Authorized, Establishment ID, Country, Citizenship Status, Minimum Age, Maximum Age, Sex, Contact ID, Area of Consideration, Draft Status, Recruitment Type, Job Family, Datetime Added, Added By, Updated, Last Updated and Recruitment Area. | PS_HRS_JOB_OPENING, PS_HRS_STS_JO_I, PS_HRS_RSN_JO_I, PS_NAMES | Ravi Swarna | Mary Rivers | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00006 | Active FullTime Positions List | This report list the all the active Positions | Position Number, Position Effective Date, Effective Date Status, Position Description, Position Short Description, Action, Reason, Action Date, Business Unit, Department ID, Job Code, Position Status, Position Status Date, Budgeted, Confidential Position, Key Positions, Max Head Count, Reports To, Full/Part Time, Last Updated Datetime, Updated By | PS_POSITION_DATA | Ravi Swarna | Katharine Cobb and Monique George | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00007 | Active FullTime Positions Open List | This report list all the active Fulltime Positions which are Open/Vacant | Position Number, Headcount Status, Position Effective Date, Effective Date Status, Position Description, Position Short Description, Action, Reason, Action Date, Business Unit, Department ID, Department ID Description, Job Code, Job Code Description, Position Status, Position Status Date, Budgeted, Confidential Position, Key Position, Max Head Count, Reports To, Full/Part Time, Last Updated Date Time, Updated By | PS_POSITION_DATA, PS_DEPT_TBL, PS_JOBCODE_TBL | Ravi Swarna | Katharine Cobb and Monique George | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00008 | Inactive FullTime Positions List | This report list all the inactive Positons | Position Number, Headcount Status, Position Effective Date, Effective Date Status, Position Description, Position Short Description, Action, Reason, Action Date, Business Unit, Department ID, Department ID Description, Job Code, Job Code Description, Position Status, Position Status Date, Budgeted, Confidential Position, Key Position, Max Head Count, Reports To, Full/Part Time, Last Updated Date Time, Updated By | PS_POSITION_DATA, PS_DEPT_TBL, PS_JOBCODE_TBL | Ravi Swarna | Katharine Cobb and Monique George | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00009 | Active FullTime Positions Job | This report list all the active FullTime Positions with current Job in active | Position Number, Heacount Status, Current Incumbent EMPLID, Position Effective Date, Effective Date Status, Position Description, Position Short Description, Action, Reason, Action Date, Business Unit, Department ID, Department ID Description, Position Status, Position Status Date, Budgeted, Confidential Position, Key Position, Max Head Count, Reports to, Full/Part Time, Last Updated Date Time, Updated By | PS_POSITION_DATA, PS_POSN_INCUMBENT, PS_JOB, PS_DEPT_TBL, PS_JOBCODE_TBL | Ravi Swarna | Katharine Cobb and Monique George | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00010 | Active PartTime Positions Open | This report list all the active PartTime Positions which are Open/vacant | Position Number, Headcount Status, Position Effective Date, Effective Date Status, Position Description, Position Short Description, Action, Reason, Action Date, Business Unit, Department ID, Department ID Description, Job Code, Job Code Description, Position Status, Position Status Date, Budgeted, Confidential Position, Key Position, Max Head Count, Reports To, Full/Part Time, Last Updated DateTime, Updated By | PS_POSITION_DATA, PS_DEPT_TBL, PS_JOBCODE_TBL | Ravi Swarna | Katharine Cobb, Monique George, Mary Rivers | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00011 | Inactive PartTime Positions | This report list all the Inactive PartTime Positions | Position Number, Headcount Status, Position Effective Date, Effective Date Status, Position Description, Position Short Description, Action, Reason, Action Date, Business Unit, Department ID, Department ID Description, Job Code, Job Code Description, Position Status, Position Status Date, Budgeted, Confidential Position, Key Position, Max Head Count, Reports To, Full/Part Time, Last Updated DateTime, Updated By | PS_POSITION_DATA, PS_DEPT_TBL, PS_JOBCODE_TBL | Ravi Swarna | Katharine Cobb, Monique George, Mary Rivers | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00012 | Active PartTime Positions Job | This report list all the active PartTime Positions with current Job active | Position Number, Headcount Status, Current Incumbent EMPLID, Position Effective Date, Effective Date Status, Position Description, Position Shot Description, Action, Reason, Action Date, Business Unit, Department ID, Department ID Description, Job Code, Job Code Description, Position Status, Position Status Date, Budgeted, Confidential Position, Key Position, Max Head Count, Reports To, Full/Part Time, Last Updated DateTime, Updated By | PS_POSITION_DATA, PS_POSN_INCUMBENT, PS_JOB, PS_DEPT_TBL, PS_JOBCODE_TBL
| Ravi Swarna | Katharine Cobb, Monique George, Mary Rivers | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00013 | Multiple Jobs Employee List | This report list you all the active employee's has multiple jobs. | Employee Id, Employee Name and No.of Jobs | PS_JOB, PS_PERSON_NAME | Ravi Swarna | New Report | Christian Keck, Joseph Marte, Monique George, Patrick Ackernan | |
CU_BAR_HR_00014 | Reports To List by Department | This report list you all the active reports to by department with name. | Department ID description, First Name, Last Name, Employee ID, Contract Title Description, Full/Part Time, Department Head Name, Assignment Begin Date, Reports To Employee ID, Reports To Name | PS_JOB, PS_DEPT_TBL, PS_PERSON_NAME, PS_JOBCODE_TBL, PS_POSN_INCUMBENT, PS_PERSON_NAME, PS_EMPLOYEES | Ravi Swarna | Katharine Cobb, Monique George | New Report | Christian Keck, Joseph Marte, Monique George, Mary Rivers |
CU_BAR_HR_00009_V4/ CU_BAR_HR_00027 | Active FT position list w/ job | Tabassum Lodhi | New Report | |||||
CU_BAR_HR_00009_V5 | Active PT position list w/ job | Tabassum Lodhi | New Report | |||||
CU_BAR_HR_00026 | Leave report | Tabassum Lodhi | ||||||