[Home] [Help] [Dependency Information]
Object Name: | HZ_EMPLOY_HIST_BO |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
ACTION_TYPE | VARCHAR2 | (30) | |
COMMON_OBJ_ID | VARCHAR2 | (255) | |
EMPLOYMENT_HISTORY_ID | NUMBER |
|
|
PERSON_ID | NUMBER |
|
|
BEGIN_DATE | DATE |
|
|
END_DATE | DATE |
|
|
EMPLOYMENT_TYPE_CODE | VARCHAR2 | (30) | |
EMPLOYED_AS_TITLE_CODE | VARCHAR2 | (30) | |
EMPLOYED_AS_TITLE | VARCHAR2 | (60) | |
EMPLOYED_BY_NAME_COMPANY | VARCHAR2 | (60) | |
EMPLOYED_BY_PARTY_ID | NUMBER |
|
|
EMPLOYED_BY_DIVISION_NAME | VARCHAR2 | (60) | |
SUPERVISOR_NAME | VARCHAR2 | (60) | |
BRANCH | VARCHAR2 | (80) | |
MILITARY_RANK | VARCHAR2 | (240) | |
SERVED | VARCHAR2 | (240) | |
STATION | VARCHAR2 | (240) | |
RESPONSIBILITY | VARCHAR2 | (240) | |
WEEKLY_WORK_HOURS | NUMBER |
|
|
REASON_FOR_LEAVING | VARCHAR2 | (240) | |
FACULTY_POSITION_FLAG | VARCHAR2 | (1) | |
TENURE_CODE | VARCHAR2 | (30) | |
FRACTION_OF_TENURE | NUMBER |
|
|
COMMENTS | VARCHAR2 | (2000) | |
STATUS | VARCHAR2 | (1) | |
PROGRAM_UPDATE_DATE | DATE |
|
|
CREATED_BY_MODULE | VARCHAR2 | (150) | |
CREATED_BY_NAME | VARCHAR2 | (100) | |
CREATION_DATE | DATE |
|
|
LAST_UPDATE_DATE | DATE |
|
|
LAST_UPDATED_BY_NAME | VARCHAR2 | (100) | |
WORK_CLASS_OBJS | HZ_WORK_CLASS_OBJ_TBL |
|
Name | Parameters | Result |
---|---|---|
CREATE_OBJECT |
P_EMPLOYMENT_HISTORY_ID(NUMBER) P_BEGIN_DATE(DATE) P_END_DATE(DATE) P_EMPLOYMENT_TYPE_CODE(VARCHAR2) P_EMPLOYED_AS_TITLE_CODE(VARCHAR2) P_EMPLOYED_AS_TITLE(VARCHAR2) P_EMPLOYED_BY_NAME_COMPANY(VARCHAR2) P_EMPLOYED_BY_PARTY_ID(NUMBER) P_EMPLOYED_BY_DIVISION_NAME(VARCHAR2) P_SUPERVISOR_NAME(VARCHAR2) P_BRANCH(VARCHAR2) P_MILITARY_RANK(VARCHAR2) P_SERVED(VARCHAR2) P_STATION(VARCHAR2) P_RESPONSIBILITY(VARCHAR2) P_WEEKLY_WORK_HOURS(NUMBER) P_REASON_FOR_LEAVING(VARCHAR2) P_FACULTY_POSITION_FLAG(VARCHAR2) P_TENURE_CODE(VARCHAR2) P_FRACTION_OF_TENURE(NUMBER) P_COMMENTS(VARCHAR2) P_STATUS(VARCHAR2) |
HZ_EMPLOY_HIST_BO |
|
|
|