eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_PE_HZ_PARTIES_M1R

Object Details

Object Name:	IGS_PE_HZ_PARTIES_M1R
Object Type:	TABLE
Owner:	IGS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory
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)

Query Text

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;

Dependencies

[top of page]

IGS.IGS_PE_HZ_PARTIES_M1R does not reference any database object

IGS.IGS_PE_HZ_PARTIES_M1R is referenced by following:

APPS: IGS_PE_HZ_PARTIES_M1R