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

VIEW: APPS.IGS_PE_HZ_PARTIES_SV

Object Details
Object Name: IGS_PE_HZ_PARTIES_SV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PE_HZ_PARTIES_SV
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

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_CD VARCHAR2 (30)
Institution Priority Code
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
BIRTH_CITY VARCHAR2 (60)
City of Birth
BIRTH_COUNTRY VARCHAR2 (30)
Country code of birth place
OSS_ORG_UNIT_CD VARCHAR2 (30)
organizational unit code.
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_CD
,      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
,      BIRTH_CITY
,      BIRTH_COUNTRY
,      OSS_ORG_UNIT_CD
,      FELONY_CONVICTED_FLAG
FROM APPS.IGS_PE_HZ_PARTIES_SV;

Dependencies

[top of page]

APPS.IGS_PE_HZ_PARTIES_SV references the following:

SchemaAPPS
SynonymIGS_PE_HZ_PARTIES
APPS.IGS_PE_HZ_PARTIES_SV is referenced by following:

SchemaAPPS
ViewIGS_PE_PERSON_SV