HR LETTER DETAIL Table
Stores HR letter and notification information, including appointment letter details, processing status, personal identifiers, appointment attributes, compensation information, and eligibility indicators used for HR correspondence and downstream reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDR_STREET1 |
Primary street address for the letter recipient. |
VARCHAR2 |
60 |
ADDR_STREET2 |
Secondary street address for the letter recipient. |
VARCHAR2 |
40 |
ANNUAL_SALARY_AMOUNT |
Annual salary amount associated with the appointment. |
NUMBER |
15,2 |
APPT_BEGIN_DATE |
Appointment begin date associated with the letter. |
DATE |
|
APPT_END_DATE |
Appointment end date associated with the letter. |
DATE |
|
APPT_SUBTY |
Appointment subtype code. |
VARCHAR2 |
4 |
APPT_TYPE |
Appointment type code. |
VARCHAR2 |
4 |
APR_TRANSACTION_STATUS |
APR transaction status associated with the letter or notification. |
VARCHAR2 |
20 |
CITY |
City of the letter recipient address. |
VARCHAR2 |
40 |
COUNTRY |
Country name for the letter recipient address. |
VARCHAR2 |
40 |
COUNTRY_CODE |
Country code for the letter recipient address. |
VARCHAR2 |
3 |
COUNTRY_OF_CITIZENSHIP |
Country of citizenship for the individual. |
VARCHAR2 |
40 |
COUNTRY_OF_CITIZENSHIP_CODE |
Country code of citizenship for the individual. |
VARCHAR2 |
3 |
DATE_PENDING |
Date the letter or notification entered a pending status. |
DATE |
|
DATE_PREPARED |
Date the letter or notification was prepared. |
DATE |
|
DATE_PROCESSED_IN_SAP |
Date the letter or notification was processed in SAP. |
DATE |
|
DATE_REJECTED |
Date the letter or notification was rejected. |
DATE |
|
DLC_KEY |
DLC (department, lab, or center) key associated with the appointment. |
VARCHAR2 |
15 |
EMPLOYEE_BEING_REPLACED |
Name or identifier of the employee being replaced. |
VARCHAR2 |
60 |
EMPLOYEE_GROUP_CODE |
Employee group code. |
VARCHAR2 |
1 |
EMPLOYEE_SUBGROUP_CODE |
Employee subgroup code. |
VARCHAR2 |
2 |
EMPLOYEE_TYPE |
Employee type associated with the appointment. |
VARCHAR2 |
30 |
FIRST_NAME |
First name of the individual associated with the letter. |
VARCHAR2 |
40 |
FORM_OF_ADDRESS_LONG |
Long form of address used in the letter salutation. |
VARCHAR2 |
15 |
FORM_OF_ADDRESS_SHORT |
Short form of address used in the letter salutation. |
VARCHAR2 |
5 |
FULL_NAME |
Full name of the individual associated with the letter. |
VARCHAR2 |
122 |
HOME_PHONE |
Home phone number of the letter recipient. |
VARCHAR2 |
14 |
HOURLY_RATE |
Hourly pay rate associated with the appointment. |
NUMBER |
5,2 |
HR_JOB_KEY |
HR job surrogate key used for joins to job data. |
VARCHAR2 |
10 |
HR_ORG_UNIT_KEY |
HR organizational unit surrogate key. |
VARCHAR2 |
10 |
HR_POSITION_KEY |
HR position surrogate key used for joins to position data. |
VARCHAR2 |
10 |
IS_ACADEMIC_HIRE |
Indicator specifying whether the hire is academic. |
VARCHAR2 |
1 |
IS_APPROVED_WAIVER |
Indicator specifying whether a waiver was approved. |
VARCHAR2 |
1 |
IS_EXEMPT |
Indicator specifying whether the position is exempt. |
VARCHAR2 |
1 |
IS_FACULTY |
Indicator specifying whether the individual is faculty. |
VARCHAR2 |
1 |
IS_OFF_CAMPUS |
Indicator specifying whether the appointment is off campus. |
VARCHAR2 |
1 |
IS_ON_MAP |
Indicator specifying whether the appointment is on MAP. |
VARCHAR2 |
1 |
IS_POSTDOC_FELLOW |
Indicator specifying whether the individual is a postdoctoral fellow. |
VARCHAR2 |
1 |
IS_RESUME_IN_WEBHIRE |
Indicator specifying whether a resume exists in Webhire. |
VARCHAR2 |
1 |
IS_SHIFT_ELIGIBLE |
Indicator specifying whether the appointment is shift-eligible. |
VARCHAR2 |
1 |
IS_US_CITIZEN |
Indicator specifying whether the individual is a U.S. citizen. |
VARCHAR2 |
1 |
JOB_CODE |
Job code associated with the appointment. |
VARCHAR2 |
8 |
JOB_TITLE |
Job title associated with the appointment. |
VARCHAR2 |
40 |
LAST_NAME |
Last name of the individual associated with the letter. |
VARCHAR2 |
40 |
LETTER_CODE |
Letter code identifying the letter template or type. |
VARCHAR2 |
2 |
MIDDLE_NAME |
Middle name of the individual associated with the letter. |
VARCHAR2 |
40 |
MONTHLY_SALARY_AMOUNT |
Monthly salary amount associated with the appointment. |
NUMBER |
15,2 |
NAME_SUFFIX |
Name suffix (short form) used in the letter. |
VARCHAR2 |
15 |
NAME_SUFFIX_LONG |
Name suffix (long form) used in the letter. |
VARCHAR2 |
15 |
NOTIFICATION_ID |
Unique identifier for the HR letter or notification record. |
NUMBER |
12 |
OFFICE_ADDR_BUILDING |
Office building identifier for the letter recipient. |
VARCHAR2 |
12 |
OFFICE_ADDR_ROOM |
Office room identifier for the letter recipient. |
VARCHAR2 |
16 |
OFFICE_ADDR_SITE |
Office site code for the letter recipient. |
VARCHAR2 |
2 |
OFFICE_PHONE |
Office phone number of the letter recipient. |
VARCHAR2 |
14 |
ORG_UNIT_ID |
Organizational unit identifier associated with the appointment. |
VARCHAR2 |
8 |
ORG_UNIT_TITLE |
Organizational unit title associated with the appointment. |
VARCHAR2 |
40 |
PAYROLL_AREA_CODE |
Payroll area code associated with the appointment. |
VARCHAR2 |
2 |
PAY_BASIS |
Pay basis description associated with the appointment. |
VARCHAR2 |
30 |
PAY_BASIS_CODE |
Pay basis code associated with the appointment. |
VARCHAR2 |
7 |
PERCENT_EFFORT |
Percentage of effort associated with the appointment. |
NUMBER |
5,2 |
PERSONNEL_AREA_CODE |
Personnel area code associated with the appointment. |
VARCHAR2 |
4 |
PERSONNEL_KEY |
Internal personnel identifier used to associate the letter with an HR personnel record. |
VARCHAR2 |
8 |
PERSONNEL_SUBAREA_CODE |
Personnel subarea code associated with the appointment. |
VARCHAR2 |
4 |
POSITION_ID |
Position identifier associated with the appointment. |
VARCHAR2 |
8 |
POSITION_TITLE |
Position title associated with the appointment. |
VARCHAR2 |
60 |
POSTAL_CODE |
Postal or ZIP code for the letter recipient address. |
VARCHAR2 |
10 |
PREPARER_KRBNAME |
Kerberos username of the individual who prepared the letter. |
VARCHAR2 |
12 |
PREPARER_NAME |
Name of the individual who prepared the letter. |
VARCHAR2 |
30 |
REGION_NAME |
Region name associated with the address. |
VARCHAR2 |
40 |
RESIDENCY_STATUS_CODE |
Residency status code associated with the individual. |
VARCHAR2 |
1 |
SCENARIO_CODE |
Scenario code identifying the letter generation scenario. |
VARCHAR2 |
4 |
SSN |
Social Security Number of the individual associated with the letter. |
VARCHAR2 |
9 |
STATE |
State or region code of the letter recipient address. |
VARCHAR2 |
3 |
TIME_GROUP |
Time group description associated with the appointment. |
VARCHAR2 |
12 |
TIME_GROUP_ID |
Time group identifier associated with the appointment. |
VARCHAR2 |
8 |
VISA_EFFECTIVE_DATE |
Visa effective start date. |
DATE |
|
VISA_EXPIRATION_DATE |
Visa expiration date. |
DATE |
|
VISA_TYPE_CODE |
Visa type code associated with the individual. |
VARCHAR2 |
4 |
WAIVER_REASON_CODE |
Code identifying the reason for the waiver. |
VARCHAR2 |
2 |
WAIVER_REASON_DESC |
Description of the waiver reason. |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
WEBHIRE_REQ_NUMBER |
Webhire requisition number associated with the appointment. |
VARCHAR2 |
12 |
WORK_HOURS |
Number of work hours associated with the appointment. |
NUMBER |
5,2 |
WORK_SCHEDULE |
Work schedule code associated with the appointment. |
VARCHAR2 |
8 |