[Home] [Help] [Dependency Information]
Object Name: | PER_CONTACT_RELATIONSHIPS_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
SOMEBODY | VARCHAR2 | (150) | ||
DUMMY_FIELD | VARCHAR2 | (150) | ||
ENTITLED_FOR_BENIFITS | VARCHAR2 | (150) | ||
ENTILTED_FOR_LOCAL_COST | VARCHAR2 | (150) | ||
ALIMONY_AMOUNT | NUMBER | |||
SEQ_NUM | NUMBER | |||
FISCAL_DEPENDENT | VARCHAR2 | (150) | ||
SINGLE_PARENT | VARCHAR2 | (150) | ||
CERT_DEPENDANT | VARCHAR2 | (150) | ||
PAY_COLL | VARCHAR2 | (150) | ||
FAMILY_ALLOWANCE_FOR_CHILD | VARCHAR2 | (150) | ||
FAMILY_TAX_ALLOWANCE_FOR_CHILD | VARCHAR2 | (150) | ||
HOLIDAY_FOR_CHILD_CARE | VARCHAR2 | (150) | ||
GUARDIAN_NAME | VARCHAR2 | (150) | ||
GUARDIAN_BIRTH_DATE | DATE | |||
GUARDIAN_ADDRESS | VARCHAR2 | (150) | ||
GUARDIAN_PHONE | VARCHAR2 | (150) | ||
SI_ITAX_FLAG | VARCHAR2 | (150) | ||
SEQUENCE | NUMBER | |||
HOUSEHOLD_HEAD_FLAG | VARCHAR2 | (150) | ||
PRIMARY_CTR_FLAG | VARCHAR2 | (150) | ||
ITAX_DPNT_FLAG | VARCHAR2 | (150) | ||
AGE_CHECK_EXCEPTION | VARCHAR2 | (150) | ||
ADDL_TAX_EXEM_FLAG | VARCHAR2 | (150) | ||
ADDL_TAX_EXEM_FLAG_CHILD | VARCHAR2 | (150) | ||
DISABLED_TAX_EXEM_FLAG | VARCHAR2 | (150) | ||
HI_DPNT_FLAG | VARCHAR2 | (150) | ||
END_REASON | VARCHAR2 | (150) | ||
KR_CONTACT_TYPE | VARCHAR2 | (150) | ||
SOLE_GUARDIAN | VARCHAR2 | (150) | ||
CHRONICALLY_III_OR_DISABLED | VARCHAR2 | (150) | ||
RELATIONSHIP_INFO | VARCHAR2 | (150) | ||
ADDRESS_INFO | VARCHAR2 | (150) | ||
EDUCATIONAL_FLAG | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (1389) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, SOMEBODY
, DUMMY_FIELD
, ENTITLED_FOR_BENIFITS
, ENTILTED_FOR_LOCAL_COST
, ALIMONY_AMOUNT
, SEQ_NUM
, FISCAL_DEPENDENT
, SINGLE_PARENT
, CERT_DEPENDANT
, PAY_COLL
, FAMILY_ALLOWANCE_FOR_CHILD
, FAMILY_TAX_ALLOWANCE_FOR_CHILD
, HOLIDAY_FOR_CHILD_CARE
, GUARDIAN_NAME
, GUARDIAN_BIRTH_DATE
, GUARDIAN_ADDRESS
, GUARDIAN_PHONE
, SI_ITAX_FLAG
, SEQUENCE
, HOUSEHOLD_HEAD_FLAG
, PRIMARY_CTR_FLAG
, ITAX_DPNT_FLAG
, AGE_CHECK_EXCEPTION
, ADDL_TAX_EXEM_FLAG
, ADDL_TAX_EXEM_FLAG_CHILD
, DISABLED_TAX_EXEM_FLAG
, HI_DPNT_FLAG
, END_REASON
, KR_CONTACT_TYPE
, SOLE_GUARDIAN
, CHRONICALLY_III_OR_DISABLED
, RELATIONSHIP_INFO
, ADDRESS_INFO
, EDUCATIONAL_FLAG
, CONCATENATED_SEGMENTS
FROM APPS.PER_CONTACT_RELATIONSHIPS_DFV;
|
|
|