Emergency Contacts for Active Ees
CT_CORE_HR_EMERGENCY_CONTACTS
Purpose of Query
Emergency Contacts for active EEs - Query provides emergency contact phone, address information for active agency employees. Excluded from this query are those employees with protected address information.
Folder
HR
Tables
CTW_EMERGCY_CNT - Emergcy Contact Rpt
Prompts
Department like (%) – (Wildcard enabled)
Sample Results
Please note, due to page size limitations, sample results may be incomplete.
Criteria
There are no criteria beyond the runtime prompts
Note: Runtime prompts are included as criteria.
Fields
Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text1 / A.EMPLID - EmplID / Char11 / 3 / Employee ID
2 / A.EMPL_RCD - Empl Rcd Nbr / Num3.0 / Empl Rcd#
3 / A.CONTACT_NAME - Contact Name / Char50 / Contact Name
4 / A.DEPTID - Department / Char10 / 1 / DeptID
5 / A.LOCATION - Location Code / Char10 / 2 / Location
6 / A.NAME - Name / Char50 / Employee Name
7 / A.CT_DEPT_DESCR - Department Description / Char30 / Deptid Descr
8 / A.CT_LOCATION_DESCR - Location Description / Char30 / Location Descr
9 / A.CT_LOC_ADDRESS1 - Location Address Line 1 / Char55 / Loc Address 1
10 / A.CT_LOC_ADDRESS2 - Location Address Line 2 / Char55 / Loc Address 2
11 / A.CT_LOC_CITY - LocationCity / Char30 / LocCity
12 / A.CT_LOC_STATE - LocationState / Char6 / LocState
13 / A.CT_LOC_POSTAL - Location Postal Code / Char12 / Loc Postal
14 / A.CT_LOC_PHONE - Location Telephone / Char24 / Loc Phone
15 / A.CT_EMPL_ADDR_TYPE - Employee Address Type / Char4 / Empl Addr Type
16 / A.CT_EMPL_COUNTRY - Employee Country / Char3 / Empl Country
17 / A.CT_EMPL_ADDRESS1 - Employee Address 1 / Char2 / N / DR/CR
18 / A.CT_EMPL_ADDRESS2 - Employee Address 2 / Char55 / Empl Address 2
19 / A.CT_EMPL_CITY - EmployeeCity / Char30 / EmplCity
20 / A.CT_EMPL_STATE - EmployeeState / Char6 / EmplState
21 / A.CT_EMPL_POSTAL - Employee Postal / Char12 / Empl Postal
22 / A.CT_EMPL_HOUSE_TYPE - Employee House Type / Char2 / N / Empl House Type
23 / A.SAME_ADDRESS_EMPL - Same Address as Employee / Char1 / Same Addr
24 / A.PRIMARY_CONTACT - Primary Contact / Char1 / Primary Cntct
25 / A.CT_CNCT_ADDR_TYPE - Contact Address Type / Char4 / Cnct Addr Type
26 / A.CT_CNCT_COUNTRY - Contact Country / Char3 / Cnct Country
27 / A.CT_CNCT_ADDRESS1 - Contact Address 1 / Char55 / Cnct Address 1
28 / A.CT_CNCT_ADDRESS2 - Contact Address 2 / Char55 / Cnct Address 2
29 / A.CT_CNCT_CITY - ContactCity / Char30 / CnctCity
30 / A.CT_CNCT_STATE - ContactState / Char6 / CnctState
31 / A.CT_CNCT_POSTAL - Contact Postal / Char12 / Cnct Postal
32 / A.CT_CNCT_HOUSE_TYPE - Contact House Type / Char2 / N / Cnct House Type
33 / A.PHONE_TYPE - Phone Type / Char4 / N / Phone Type
34 / A.SAME_PHONE_EMPL - Same Phone as Employee / Char1 / Same Phone
35 / A.CT_CNTCT_PHONE - Contact Telephone / Char24 / Cnct Phone
36 / A.RELATIONSHIP - Relationship to Employee / Char2 / N / Relation
37 / A.CT_PERSONAL_PHONE - Personal Telephone / Char24 / Personal Phone
38 / A.CT_EMERGPH_TYPE - Emergency Phone Type / Char4 / N / Emeg Phone Type
39 / A.CT_EMERG_PHONE - Emergency Telephone / Char24 / Emegcy Phone
40 / A.CT_CAMP_ADDR1 - CampAddress Line 1 / Char55 / CampAddress 1
41 / A.CT_CAMP_ADDR2 - CampAddress Line 2 / Char55 / CampAddress 2
42 / A.CT_CAMP_CITY - CampCity / Char30 / CampCity
43 / A.CT_CAMP_STATE - CampState / Char6 / CampState
44 / A.CT_CAMP_POSTAL - Camp Postal Code / Char12 / Camp Postal