[Home] [Help] [Dependency Information]
Object Name: | IGS_PE_HZ_PARTIES_M1R |
---|---|
Object Type: | TABLE |
Owner: | IGS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARTY_ID | NUMBER | (15) | Yes | |
DECEASED_IND | VARCHAR2 | (1) | ||
ARCHIVE_EXCLUSION_IND | VARCHAR2 | (1) | ||
ARCHIVE_DT | DATE | |||
PURGE_EXCLUSION_IND | VARCHAR2 | (1) | ||
PURGE_DT | DATE | |||
ORACLE_USERNAME | VARCHAR2 | (100) | ||
PROOF_OF_INS | VARCHAR2 | (1) | ||
PROOF_OF_IMMU | VARCHAR2 | (1) | ||
LEVEL_OF_QUAL | NUMBER | (15) | ||
MILITARY_SERVICE_REG | VARCHAR2 | (1) | ||
VETERAN | VARCHAR2 | (30) | ||
INSTITUTION_CD | VARCHAR2 | (30) | ||
OI_LOCAL_INSTITUTION_IND | VARCHAR2 | (1) | ||
OI_OS_IND | VARCHAR2 | (1) | ||
OI_GOVT_INSTITUTION_CD | VARCHAR2 | (30) | ||
OI_INST_CONTROL_TYPE | VARCHAR2 | (30) | ||
OI_INSTITUTION_TYPE | VARCHAR2 | (20) | ||
OI_INSTITUTION_STATUS | VARCHAR2 | (10) | ||
OU_START_DT | DATE | |||
OU_END_DT | DATE | |||
OU_MEMBER_TYPE | VARCHAR2 | (30) | ||
OU_ORG_STATUS | VARCHAR2 | (10) | ||
OU_ORG_TYPE | VARCHAR2 | (30) | ||
INST_ORG_IND | VARCHAR2 | (1) | ||
INST_PRIORITY_CODE_ID | NUMBER | (15) | ||
INST_EPS_CODE | VARCHAR2 | (8) | ||
INST_PHONE_COUNTRY_CODE | VARCHAR2 | (10) | ||
INST_PHONE_AREA_CODE | VARCHAR2 | (10) | ||
INST_PHONE_NUMBER | VARCHAR2 | (40) | ||
ADV_STUDIES_CLASSES | NUMBER | |||
HONORS_CLASSES | NUMBER | |||
CLASS_SIZE | NUMBER | |||
SEC_SCHOOL_LOCATION_ID | NUMBER | (15) | ||
PERCENT_PLAN_HIGHER_EDU | NUMBER | |||
FUND_AUTHORIZATION | VARCHAR2 | (1) | ||
PE_INFO_VERIFY_TIME | DATE | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
INST_PRIORITY_CD | VARCHAR2 | (30) | ||
BIRTH_CITY | VARCHAR2 | (60) | ||
BIRTH_COUNTRY | VARCHAR2 | (30) | ||
OSS_ORG_UNIT_CD | VARCHAR2 | (30) | ||
FELONY_CONVICTED_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, DECEASED_IND
, ARCHIVE_EXCLUSION_IND
, ARCHIVE_DT
, PURGE_EXCLUSION_IND
, PURGE_DT
, ORACLE_USERNAME
, PROOF_OF_INS
, PROOF_OF_IMMU
, LEVEL_OF_QUAL
, MILITARY_SERVICE_REG
, VETERAN
, INSTITUTION_CD
, OI_LOCAL_INSTITUTION_IND
, OI_OS_IND
, OI_GOVT_INSTITUTION_CD
, OI_INST_CONTROL_TYPE
, OI_INSTITUTION_TYPE
, OI_INSTITUTION_STATUS
, OU_START_DT
, OU_END_DT
, OU_MEMBER_TYPE
, OU_ORG_STATUS
, OU_ORG_TYPE
, INST_ORG_IND
, INST_PRIORITY_CODE_ID
, INST_EPS_CODE
, INST_PHONE_COUNTRY_CODE
, INST_PHONE_AREA_CODE
, INST_PHONE_NUMBER
, ADV_STUDIES_CLASSES
, HONORS_CLASSES
, CLASS_SIZE
, SEC_SCHOOL_LOCATION_ID
, PERCENT_PLAN_HIGHER_EDU
, FUND_AUTHORIZATION
, PE_INFO_VERIFY_TIME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INST_PRIORITY_CD
, BIRTH_CITY
, BIRTH_COUNTRY
, OSS_ORG_UNIT_CD
, FELONY_CONVICTED_FLAG
FROM IGS.IGS_PE_HZ_PARTIES_M1R;
IGS.IGS_PE_HZ_PARTIES_M1R does not reference any database object
IGS.IGS_PE_HZ_PARTIES_M1R is referenced by following:
|
|
|