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

TABLE: IGS.IGS_AD_PS_APLINSTHST_ALL

Object Details
Object Name: IGS_AD_PS_APLINSTHST_ALL
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_AD_PS_APLINSTHST_ALL
Subobject Name:
Status: VALID


IGS_AD_PS_APLINSTHST_ALL describes history of changes to admission program
application instance.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AD_PS_APLINSTHST_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
ColumnADMISSION_APPL_NUMBER
ColumnNOMINATED_COURSE_CD
ColumnSEQUENCE_NUMBER
ColumnHIST_START_DT
IGS_AD_PS_APLINSTHST_ALL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADM_ENTRY_QUAL_STATUS
IGS_AD_PS_APLINSTHST_ALL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADM_DOC_STATUS
IGS_AD_PS_APLINSTHST_ALL_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLATE_ADM_FEE_STATUS
IGS_AD_PS_APLINSTHST_ALL_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADM_OUTCOME_STATUS
IGS_AD_PS_APLINSTHST_ALL_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADM_OFFER_RESP_STATUS
IGS_AD_PS_APLINSTHST_ALL_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADM_CNDTNL_OFFER_STATUS
IGS_AD_PS_APLINSTHST_ALL_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADM_OFFER_DFRMNT_STATUS
Columns
Name Datatype Length Mandatory Comments
ORG_ID NUMBER (15)
Operating unit identifier
PERSON_ID NUMBER (15) Yes Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
ADMISSION_APPL_NUMBER NUMBER (2) Yes Uniquely identifies an admission application for a person.
NOMINATED_COURSE_CD VARCHAR2 (6) Yes Describes the program code of the program offering instance that the person is applying for admission to.
SEQUENCE_NUMBER NUMBER (6) Yes Unique identifier of an admission program application instance. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type and unit set code.
HIST_START_DT DATE
Yes The effective start date and time of the history record.
HIST_END_DT DATE
Yes The effective end date and time of the history record.
HIST_WHO NUMBER (15) Yes The Oracle username of the person who created the history record.
HIST_OFFER_ROUND_NUMBER NUMBER (2)
Describes the number of the offer round the history was created for. This value will only be set as a result of offer round processing.
ADM_CAL_TYPE VARCHAR2 (10)
Describes the calendar type of the admission period
ADM_CI_SEQUENCE_NUMBER NUMBER (6)
Describes the calendar sequence number of the admission period
COURSE_CD VARCHAR2 (6)
Describes the program code of the admission application
CRV_VERSION_NUMBER NUMBER (3)
Describes the program version number of the admission application
LOCATION_CD VARCHAR2 (10)
Describes the location code of the program admission application
ATTENDANCE_MODE VARCHAR2 (2)
Describes the attendance mode of the program admission application
ATTENDANCE_TYPE VARCHAR2 (2)
Describes the attendance type of the program admission application
UNIT_SET_CD VARCHAR2 (10)
Describes the unit set code of the program admission application
US_VERSION_NUMBER NUMBER (3)
Describes the version number of the unit set code of the program admission application
PREFERENCE_NUMBER NUMBER (2)
Describes the applicant preference number of the program applied for
ADM_DOC_STATUS VARCHAR2 (10)
Describes the documentation status of the admission program application instance
ADM_ENTRY_QUAL_STATUS VARCHAR2 (10)
Describes the entry qualification status of the admission program application instance
LATE_ADM_FEE_STATUS VARCHAR2 (10)
Describes the institution-defined fee status for a late program admission application instance
ADM_OUTCOME_STATUS VARCHAR2 (10)
Describes the outcome status of the admission program application instance
ADM_OTCM_STATUS_AUTH_PERSON_ID NUMBER (15)
Describes the ID of the person who authorized the outcome status
ADM_OUTCOME_STATUS_AUTH_DT DATE

Describes the date that the outcome status was authorized
ADM_OUTCOME_STATUS_REASON VARCHAR2 (60)
Used to further describe a status, for example, an outcome status of 'Revoked' may have associated reason for the revocation.
OFFER_DT DATE

Describes the date that an offer of admission was made to the applicant
OFFER_RESPONSE_DT DATE

Indicates the date by which an applicant must respond to the offer of admission. After this date, the offer would be expired by the process that changes the offer response status to LAPSED.
PRPSD_COMMENCEMENT_DT DATE

Describes the proposed commencement date for an admission program application instance.
ADM_CNDTNL_OFFER_STATUS VARCHAR2 (10)
Describes the status assigned to an admission program application in relation to a conditional offer
CNDTNL_OFFER_SATISFIED_DT DATE

Describes the date that a conditional offer was satisfied or waived
CNDTNL_OFFER_MUST_BE_STSFD_IND VARCHAR2 (1)
Describes whether or not a conditional offer must be satisfied before the offer can be accepted
ADM_OFFER_RESP_STATUS VARCHAR2 (10)
Describes the offer response status of the admission program application instance
ACTUAL_RESPONSE_DT DATE

Describes the actual date a response was made by an applicant to an offer
ADM_OFFER_DFRMNT_STATUS VARCHAR2 (10)
Describes the offer deferment status of the admission program application instance
DEFERRED_ADM_CAL_TYPE VARCHAR2 (10)
Describes the admission calendar type of the admission period that the offer has been deferred to
DEFERRED_ADM_CI_SEQUENCE_NUM NUMBER (6)
Describes the academic calendar sequence number of the admission period that the offer has been deferred to
DEFERRED_TRACKING_ID NUMBER (9)
Describes the tracking ID of the deferral request that has been forwarded for assessment
ASS_RANK NUMBER (3)
Rank of applicant if offers are determined by comparing all applicants and choosing the highest ranked to satisfy program quotas.
SECONDARY_ASS_RANK NUMBER (3)
Secondary ranking of an applicant if the desire is to force an offer, or restrict an offer when determining program offers by comparing all applicants.
INTRNTNL_ACCEPTANCE_ADVICE_NUM NUMBER (15)
The number on the government window that goes with the offer letter for international applicants to take to the embassy overseas to get their visa.
ASS_TRACKING_ID NUMBER (9)
Describes the tracking ID of an application that has been forwarded for assessment
FEE_CAT VARCHAR2 (10)
The Fee Category applicable to the program admission. Fee categories are used to define the set of fees and charges applicable to a student studying a particular program.
HECS_PAYMENT_OPTION VARCHAR2 (10)
Describes the HECS payment option associated with an offer. This will enable enrollment fee invoices to be produced.
EXPECTED_COMPLETION_YR NUMBER (4)
The year in which the assessor considers the applicant will have completed all program requirements. The assessor also nominates the expected period like Summer, Mid-year or End of Year of program completion. This information can be derived from the program version standard F or T and P or T completion time values but may need to be overridden when advanced standing is a consideration. This information will also enable the determination of fee-paying applicant contract durations.
EXPECTED_COMPLETION_PERD VARCHAR2 (1)
The period, or part of the year, at which time the assessor considers the applicant will have completed all program requirements. The allowable values are Summer, Mid-year or End of Year.
CORRESPONDENCE_CAT VARCHAR2 (10)
The correspondence category applicable to the student's program admission. Correspondence categories are used to define the set of system generated and non-system originated correspondence items that will be send to the student.
ENROLMENT_CAT VARCHAR2 (10)
A unique institution-defined code used to describe an enrollment category. Enrollment categories are used to define the processes and procedures involved in the enrollment of particular groups of students.
FUNDING_SOURCE VARCHAR2 (10)
A unique identifier for the institution-defined funding source. This must be mapped to a Government funding source.
APPLICANT_ACPTNCE_CNDTN VARCHAR2 (2000)
Describes the conditions the applicant is requesting as part of their acceptance of an offer, for example, request for scholarship granted, advanced standing approved.
CNDTNL_OFFER_CNDTN VARCHAR2 (2000)
Describes the conditions of a conditional offer. An assessor may use this field to list conditions the applicant must satisfy in order to satisfy the conditional offer.
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
APPL_INST_STATUS VARCHAR2 (10)
Application Instance Status
DECISION_DATE DATE

Date when the decision is made
DECISION_MAKE_ID NUMBER (15)
Decision maker person identifier
DECISION_REASON_ID NUMBER (15)
Decision reason
PENDING_REASON_ID NUMBER (15)
Pending Reason
WAITLIST_STATUS VARCHAR2 (30)
This field will be populated only for Outcome Status of "Applicant has been added to a waitlist". Valid values for Waitlist Status are PENDING, ACTIVE and INACTIVE
WAITLIST_RANK VARCHAR2 (3)
Waitlist Rank
FUTURE_ACAD_CAL_TYPE VARCHAR2 (10)
Future academic calendar type
FUTURE_ACAD_CI_SEQUENCE_NUM NUMBER (6)
Future academic calendar type instance
FUTURE_ADM_CAL_TYPE VARCHAR2 (10)
Future admission calendar type
FUTURE_ADM_CI_SEQUENCE_NUM NUMBER (6)
Future Admission Calendar Type Instance
DEF_ACAD_CAL_TYPE VARCHAR2 (10)
Deferred Academic Calendar Type
DEF_ACAD_CI_SEQUENCE_NUM NUMBER (6)
Deferred Academic Calendar Sequence number
RECONSIDER_FLAG VARCHAR2 (1)
Reconsideration Flag
DECLINE_OFR_REASON VARCHAR2 (60)
Reason for declining offer
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      SEQUENCE_NUMBER
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      HIST_OFFER_ROUND_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      COURSE_CD
,      CRV_VERSION_NUMBER
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      PREFERENCE_NUMBER
,      ADM_DOC_STATUS
,      ADM_ENTRY_QUAL_STATUS
,      LATE_ADM_FEE_STATUS
,      ADM_OUTCOME_STATUS
,      ADM_OTCM_STATUS_AUTH_PERSON_ID
,      ADM_OUTCOME_STATUS_AUTH_DT
,      ADM_OUTCOME_STATUS_REASON
,      OFFER_DT
,      OFFER_RESPONSE_DT
,      PRPSD_COMMENCEMENT_DT
,      ADM_CNDTNL_OFFER_STATUS
,      CNDTNL_OFFER_SATISFIED_DT
,      CNDTNL_OFFER_MUST_BE_STSFD_IND
,      ADM_OFFER_RESP_STATUS
,      ACTUAL_RESPONSE_DT
,      ADM_OFFER_DFRMNT_STATUS
,      DEFERRED_ADM_CAL_TYPE
,      DEFERRED_ADM_CI_SEQUENCE_NUM
,      DEFERRED_TRACKING_ID
,      ASS_RANK
,      SECONDARY_ASS_RANK
,      INTRNTNL_ACCEPTANCE_ADVICE_NUM
,      ASS_TRACKING_ID
,      FEE_CAT
,      HECS_PAYMENT_OPTION
,      EXPECTED_COMPLETION_YR
,      EXPECTED_COMPLETION_PERD
,      CORRESPONDENCE_CAT
,      ENROLMENT_CAT
,      FUNDING_SOURCE
,      APPLICANT_ACPTNCE_CNDTN
,      CNDTNL_OFFER_CNDTN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      APPL_INST_STATUS
,      DECISION_DATE
,      DECISION_MAKE_ID
,      DECISION_REASON_ID
,      PENDING_REASON_ID
,      WAITLIST_STATUS
,      WAITLIST_RANK
,      FUTURE_ACAD_CAL_TYPE
,      FUTURE_ACAD_CI_SEQUENCE_NUM
,      FUTURE_ADM_CAL_TYPE
,      FUTURE_ADM_CI_SEQUENCE_NUM
,      DEF_ACAD_CAL_TYPE
,      DEF_ACAD_CI_SEQUENCE_NUM
,      RECONSIDER_FLAG
,      DECLINE_OFR_REASON
FROM IGS.IGS_AD_PS_APLINSTHST_ALL;

Dependencies

[top of page]

IGS.IGS_AD_PS_APLINSTHST_ALL does not reference any database object

IGS.IGS_AD_PS_APLINSTHST_ALL is referenced by following:

SchemaAPPS
SynonymIGS_AD_PS_APLINSTHST_ALL