[Home] [Help] [Dependency Information]
Object Name: | HZ_PERSON_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) | |
PERSON_ID | NUMBER |
|
|
ORIG_SYSTEM | VARCHAR2 | (30) | |
ORIG_SYSTEM_REFERENCE | VARCHAR2 | (255) | |
PARTY_NUMBER | VARCHAR2 | (30) | |
VALIDATED_FLAG | VARCHAR2 | (1) | |
STATUS | VARCHAR2 | (1) | |
CATEGORY_CODE | VARCHAR2 | (30) | |
SALUTATION | VARCHAR2 | (60) | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | |
ATTRIBUTE1 | VARCHAR2 | (150) | |
ATTRIBUTE2 | VARCHAR2 | (150) | |
ATTRIBUTE3 | VARCHAR2 | (150) | |
ATTRIBUTE4 | VARCHAR2 | (150) | |
ATTRIBUTE5 | VARCHAR2 | (150) | |
ATTRIBUTE6 | VARCHAR2 | (150) | |
ATTRIBUTE7 | VARCHAR2 | (150) | |
ATTRIBUTE8 | VARCHAR2 | (150) | |
ATTRIBUTE9 | VARCHAR2 | (150) | |
ATTRIBUTE10 | VARCHAR2 | (150) | |
ATTRIBUTE11 | VARCHAR2 | (150) | |
ATTRIBUTE12 | VARCHAR2 | (150) | |
ATTRIBUTE13 | VARCHAR2 | (150) | |
ATTRIBUTE14 | VARCHAR2 | (150) | |
ATTRIBUTE15 | VARCHAR2 | (150) | |
ATTRIBUTE16 | VARCHAR2 | (150) | |
ATTRIBUTE17 | VARCHAR2 | (150) | |
ATTRIBUTE18 | VARCHAR2 | (150) | |
ATTRIBUTE19 | VARCHAR2 | (150) | |
ATTRIBUTE20 | VARCHAR2 | (150) | |
ATTRIBUTE21 | VARCHAR2 | (150) | |
ATTRIBUTE22 | VARCHAR2 | (150) | |
ATTRIBUTE23 | VARCHAR2 | (150) | |
ATTRIBUTE24 | VARCHAR2 | (150) | |
PERSON_PRE_NAME_ADJUNCT | VARCHAR2 | (30) | |
PERSON_FIRST_NAME | VARCHAR2 | (150) | |
PERSON_MIDDLE_NAME | VARCHAR2 | (60) | |
PERSON_LAST_NAME | VARCHAR2 | (150) | |
PERSON_NAME_SUFFIX | VARCHAR2 | (30) | |
PERSON_TITLE | VARCHAR2 | (60) | |
PERSON_ACADEMIC_TITLE | VARCHAR2 | (30) | |
PERSON_PREVIOUS_LAST_NAME | VARCHAR2 | (150) | |
PERSON_INITIALS | VARCHAR2 | (6) | |
KNOWN_AS | VARCHAR2 | (240) | |
KNOWN_AS2 | VARCHAR2 | (240) | |
KNOWN_AS3 | VARCHAR2 | (240) | |
KNOWN_AS4 | VARCHAR2 | (240) | |
KNOWN_AS5 | VARCHAR2 | (240) | |
PERSON_NAME_PHONETIC | VARCHAR2 | (320) | |
PERSON_FIRST_NAME_PHONETIC | VARCHAR2 | (60) | |
PERSON_LAST_NAME_PHONETIC | VARCHAR2 | (60) | |
MIDDLE_NAME_PHONETIC | VARCHAR2 | (60) | |
TAX_REFERENCE | VARCHAR2 | (50) | |
JGZZ_FISCAL_CODE | VARCHAR2 | (20) | |
PERSON_IDEN_TYPE | VARCHAR2 | (30) | |
PERSON_IDENTIFIER | VARCHAR2 | (60) | |
DATE_OF_BIRTH | DATE |
|
|
PLACE_OF_BIRTH | VARCHAR2 | (60) | |
DATE_OF_DEATH | DATE |
|
|
DECEASED_FLAG | VARCHAR2 | (1) | |
GENDER | VARCHAR2 | (30) | |
DECLARED_ETHNICITY | VARCHAR2 | (60) | |
MARITAL_STATUS | VARCHAR2 | (30) | |
MARITAL_STATUS_EFF_DATE | DATE |
|
|
PERSONAL_INCOME | NUMBER |
|
|
HEAD_OF_HOUSEHOLD_FLAG | VARCHAR2 | (1) | |
HOUSEHOLD_INCOME | NUMBER |
|
|
HOUSEHOLD_SIZE | NUMBER |
|
|
RENT_OWN_IND | VARCHAR2 | (30) | |
LAST_KNOWN_GPS | VARCHAR2 | (60) | |
INTERNAL_FLAG | VARCHAR2 | (2) | |
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) | |
ACTUAL_CONTENT_SOURCE | VARCHAR2 | (30) | |
ORIG_SYS_OBJS | HZ_ORIG_SYS_REF_OBJ_TBL |
|
|
EXT_ATTRIBUTES_OBJS | HZ_EXT_ATTRIBUTE_OBJ_TBL |
|
|
PARTY_SITE_OBJS | HZ_PARTY_SITE_BO_TBL |
|
|
PREFERENCE_OBJS | HZ_PARTY_PREF_OBJ_TBL |
|
|
RELATIONSHIP_OBJS | HZ_RELATIONSHIP_OBJ_TBL |
|
|
PHONE_OBJS | HZ_PHONE_CP_BO_TBL |
|
|
EMAIL_OBJS | HZ_EMAIL_CP_BO_TBL |
|
|
WEB_OBJS | HZ_WEB_CP_BO_TBL |
|
|
SMS_OBJS | HZ_SMS_CP_BO_TBL |
|
|
CLASS_OBJS | HZ_CODE_ASSIGNMENT_OBJ_TBL |
|
|
LANGUAGE_OBJS | HZ_PERSON_LANG_OBJ_TBL |
|
|
EDUCATION_OBJS | HZ_EDUCATION_OBJ_TBL |
|
|
CITIZENSHIP_OBJS | HZ_CITIZENSHIP_OBJ_TBL |
|
|
EMPLOY_HIST_OBJS | HZ_EMPLOY_HIST_BO_TBL |
|
|
INTEREST_OBJS | HZ_PERSON_INTEREST_OBJ_TBL |
|
|
CERTIFICATION_OBJS | HZ_CERTIFICATION_OBJ_TBL |
|
|
FINANCIAL_PROF_OBJS | HZ_FINANCIAL_PROF_OBJ_TBL |
|
|
CONTACT_PREF_OBJS | HZ_CONTACT_PREF_OBJ_TBL |
|
|
PARTY_USAGE_OBJS | HZ_PARTY_USAGE_OBJ_TBL |
|
Name | Parameters | Result |
---|---|---|
CREATE_OBJECT |
P_PERSON_ID(NUMBER) P_ORIG_SYSTEM(VARCHAR2) P_ORIG_SYSTEM_REFERENCE(VARCHAR2) P_PARTY_NUMBER(VARCHAR2) P_VALIDATED_FLAG(VARCHAR2) P_STATUS(VARCHAR2) P_CATEGORY_CODE(VARCHAR2) P_SALUTATION(VARCHAR2) P_ATTRIBUTE_CATEGORY(VARCHAR2) P_ATTRIBUTE1(VARCHAR2) P_ATTRIBUTE2(VARCHAR2) P_ATTRIBUTE3(VARCHAR2) P_ATTRIBUTE4(VARCHAR2) P_ATTRIBUTE5(VARCHAR2) P_ATTRIBUTE6(VARCHAR2) P_ATTRIBUTE7(VARCHAR2) P_ATTRIBUTE8(VARCHAR2) P_ATTRIBUTE9(VARCHAR2) P_ATTRIBUTE10(VARCHAR2) P_ATTRIBUTE11(VARCHAR2) P_ATTRIBUTE12(VARCHAR2) P_ATTRIBUTE13(VARCHAR2) P_ATTRIBUTE14(VARCHAR2) P_ATTRIBUTE15(VARCHAR2) P_ATTRIBUTE16(VARCHAR2) P_ATTRIBUTE17(VARCHAR2) P_ATTRIBUTE18(VARCHAR2) P_ATTRIBUTE19(VARCHAR2) P_ATTRIBUTE20(VARCHAR2) P_ATTRIBUTE21(VARCHAR2) P_ATTRIBUTE22(VARCHAR2) P_ATTRIBUTE23(VARCHAR2) P_ATTRIBUTE24(VARCHAR2) P_PERSON_PRE_NAME_ADJUNCT(VARCHAR2) P_PERSON_FIRST_NAME(VARCHAR2) P_PERSON_MIDDLE_NAME(VARCHAR2) P_PERSON_LAST_NAME(VARCHAR2) P_PERSON_NAME_SUFFIX(VARCHAR2) P_PERSON_TITLE(VARCHAR2) P_PERSON_ACADEMIC_TITLE(VARCHAR2) P_PERSON_PREVIOUS_LAST_NAME(VARCHAR2) P_PERSON_INITIALS(VARCHAR2) P_KNOWN_AS(VARCHAR2) P_KNOWN_AS2(VARCHAR2) P_KNOWN_AS3(VARCHAR2) P_KNOWN_AS4(VARCHAR2) P_KNOWN_AS5(VARCHAR2) P_PERSON_NAME_PHONETIC(VARCHAR2) P_PERSON_FIRST_NAME_PHONETIC(VARCHAR2) P_PERSON_LAST_NAME_PHONETIC(VARCHAR2) P_MIDDLE_NAME_PHONETIC(VARCHAR2) P_TAX_REFERENCE(VARCHAR2) P_JGZZ_FISCAL_CODE(VARCHAR2) P_PERSON_IDEN_TYPE(VARCHAR2) P_PERSON_IDENTIFIER(VARCHAR2) P_DATE_OF_BIRTH(DATE) P_PLACE_OF_BIRTH(VARCHAR2) P_DATE_OF_DEATH(DATE) P_DECEASED_FLAG(VARCHAR2) P_GENDER(VARCHAR2) P_DECLARED_ETHNICITY(VARCHAR2) P_MARITAL_STATUS(VARCHAR2) P_MARITAL_STATUS_EFF_DATE(DATE) P_PERSONAL_INCOME(NUMBER) P_HEAD_OF_HOUSEHOLD_FLAG(VARCHAR2) P_HOUSEHOLD_INCOME(NUMBER) P_HOUSEHOLD_SIZE(NUMBER) P_RENT_OWN_IND(VARCHAR2) P_LAST_KNOWN_GPS(VARCHAR2) P_INTERNAL_FLAG(VARCHAR2) P_ACTUAL_CONTENT_SOURCE(VARCHAR2) |
HZ_PERSON_BO |
|
|
|