Tuesday, May 6, 2008

Employee Primary Emergency Contact Information

Employee primary emergency contact information is now available in the ASU Data Warehouse table, PS_ASU_D_EMP_AR_VW. See fields Emerg_Cntct_Nm and Emerg_Phone_Num.

Previously, if an employee selected the option that the primary emergency contact's phone number was as the same as the employee's home phone number, Emerg_Phone_Num would be blank in PS_ASU_D_EMP_AR_VW. This has been changed so that the employee's home phone number now appears in the Emerg_Phone_Num.

A query named "Emergency Contact.bqy" is available in the myReports Human Resource folder.

More complete emergency contact information is available in the PS_EMERGENCY_CNTCT table.

No comments: