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

Object Details

Object Name:	IGS_PE_HZ_PARTIES
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_PE_HZ_PARTIES
Subobject Name:
Status:	VALID

IGS_PE_HZ_PARTIES describes the attributes of a person.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_PE_HZ_PARTIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_ID
IGS_PE_HZ_PARTIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OSS_ORG_UNIT_CD
IGS_PE_HZ_PARTIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INSTITUTION_CD
IGS_PE_HZ_PARTIES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INST_ORG_IND

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	Unique identifier of the party
DECEASED_IND	VARCHAR2	(1)		Flag indicates whether the Person Party is deceased.
ARCHIVE_EXCLUSION_IND	VARCHAR2	(1)		Flag indicates whether the Person Party is excluded from archive.
ARCHIVE_DT	DATE			Archive date of the person
PURGE_EXCLUSION_IND	VARCHAR2	(1)		Flag indicates whether Person Party is excluded from purging.
PURGE_DT	DATE			Purge date of the person
ORACLE_USERNAME	VARCHAR2	(100)		Oracle user name
PROOF_OF_INS	VARCHAR2	(1)		Proof of insurance
PROOF_OF_IMMU	VARCHAR2	(1)		Proof of immunization
LEVEL_OF_QUAL	NUMBER	(15)		Identifier for level of qualification of the Person Party.
MILITARY_SERVICE_REG	VARCHAR2	(1)		Military service registration
VETERAN	VARCHAR2	(30)		Status indicating whether a person party should be considered as a Veteran and the Veteran Type.
INSTITUTION_CD	VARCHAR2	(30)		Identifier code of the institution
OI_LOCAL_INSTITUTION_IND	VARCHAR2	(1)		Flag indicates whether institution is local or not. Local institution is the install site of Oracle Student System.
OI_OS_IND	VARCHAR2	(1)		Overseas institution indicator
OI_GOVT_INSTITUTION_CD	VARCHAR2	(30)		Government institution code
OI_INST_CONTROL_TYPE	VARCHAR2	(30)		Organizational institute control type
OI_INSTITUTION_TYPE	VARCHAR2	(20)		Type of Institution. Applicable only for records of Institution Party.
OI_INSTITUTION_STATUS	VARCHAR2	(10)		Status of the Institution. Applicable only for records of Institution Party.
OU_START_DT	DATE			Start date of the organization unit
OU_END_DT	DATE			End date of the organization unit
OU_MEMBER_TYPE	VARCHAR2	(30)		Indicator for the Member Type for the Organization Party
OU_ORG_STATUS	VARCHAR2	(10)		Organization status
OU_ORG_TYPE	VARCHAR2	(30)		Organization type
INST_ORG_IND	VARCHAR2	(1)		Indicates whether the party is an Organization or an Institution for Oracle Student System.I- Institution, O- Organization and a Null indicates that the party is a Person Party.
INST_PRIORITY_CODE_ID	NUMBER	(15)		Indicates the Institution Priority Code - OBSOLETE
INST_EPS_CODE	VARCHAR2	(8)		Indicates the Institution Market Code
INST_PHONE_COUNTRY_CODE	VARCHAR2	(10)		Indicates the Institution Phone Country Code
INST_PHONE_AREA_CODE	VARCHAR2	(10)		Indicates the Institution Phone Area Code
INST_PHONE_NUMBER	VARCHAR2	(40)		Indicates the Institution Phone Number
ADV_STUDIES_CLASSES	NUMBER			Indicates the number of Advanced Studies Classes Offered
HONORS_CLASSES	NUMBER			Indicates the number of Honors classes offered
CLASS_SIZE	NUMBER			Indicates the class size
SEC_SCHOOL_LOCATION_ID	NUMBER	(15)		Indicates the secondary school location identifier
PERCENT_PLAN_HIGHER_EDU	NUMBER			Indicates the percentage of students planning to pursue higher education
FUND_AUTHORIZATION	VARCHAR2	(1)		This identifies if the Person has Funds Authorization or not.
PE_INFO_VERIFY_TIME	DATE			Student's information verification Time. Self Service will use this information . Every Time the student logs into the system, this field will be used to check if he needs to verify again for the information corresponding to him
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Request identifier of the last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER	(15)		Program application identifier of the last concurrent program to update this record
PROGRAM_ID	NUMBER	(15)		Program identifier of the last concurrent program to update this record
PROGRAM_UPDATE_DATE	DATE			Last update date by the concurrent program
INST_PRIORITY_CD	VARCHAR2	(30)		Institution Priority Code
BIRTH_CITY	VARCHAR2	(60)		City of Birth
BIRTH_COUNTRY	VARCHAR2	(30)		Country code of birth place
OSS_ORG_UNIT_CD	VARCHAR2	(30)		Code for the Organization or Institution that will be recognized by OSS. All tables referring to Organization will have Foreign Key with this column and Not HZ_PARTIES.PARTY_NUMBER
FELONY_CONVICTED_FLAG	VARCHAR2	(1)		Flag indicating whether the person is ever convicted of a Felony

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;

Dependencies

[top of page]

IGS.IGS_PE_HZ_PARTIES does not reference any database object

IGS.IGS_PE_HZ_PARTIES is referenced by following:

APPS: IGS_PE_HZ_PARTIES