Skip to content

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

TABLE: IGS.IGS_PE_PERS_PREFS_ALL

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


IGS_PE_PERS_PREFS_ALL describes the preferences for a person within OSS. These preferences include the 'record enrollments session details'.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_PE_PERS_PREFS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
Columns
Name Datatype Length Mandatory Comments
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
PERSON_ID NUMBER (15) Yes Identifier that uniquely identifies a person
ENR_ACAD_CAL_TYPE VARCHAR2 (10)
The last academic calendar type used through the record enrollments process
ENR_ACAD_SEQUENCE_NUMBER NUMBER (6)
Sequence number of the last academic calendar type used through the record enrollments process
ENR_ENROLMENT_CAT VARCHAR2 (10)
The last enrollment category used through the record enrollments process
ENR_ENR_METHOD_TYPE VARCHAR2 (10)
The last enrollment method used through the record enrollments process.
ADM_ACAD_CAL_TYPE VARCHAR2 (10)
Describes the last academic calendar type used through the direct admissions process
ADM_ACAD_CI_SEQUENCE_NUMBER NUMBER (6)
Describes the sequence number of the last academic calendar instance used through the direct admissions process
ADM_ADM_CAL_TYPE VARCHAR2 (10)
Describes the last admission calendar type used through the direct admissions process
ADM_ADM_CI_SEQUENCE_NUMBER NUMBER (6)
Describes the sequence number of the last admission calendar instance used through the direct admissions process
ADM_ADMISSION_CAT VARCHAR2 (10)
Describes the last admission category used through the direct admissions process.
ADM_S_ADMISSION_PROCESS_TYPE VARCHAR2 (10)
Describes the last system admission process type used through the direct admissions process
ENQ_ACAD_CAL_TYPE VARCHAR2 (10)
Captures information about the enquiry academic calendar type
ENQ_ACAD_CI_SEQUENCE_NUMBER NUMBER (6)
Sequence number that identifies an academic citation
ENQ_ADM_CAL_TYPE VARCHAR2 (10)
Captures an enquiry admission calendar type
ENQ_ADM_CI_SEQUENCE_NUMBER NUMBER (6)
Captures a unique admission sequence number
SERVER_PRINTER_DFLT VARCHAR2 (30)
Name of the networked printer to be used as the person's default for outputs generated by the job scheduler facility
ALLOW_STND_REQ_IND VARCHAR2 (1) Yes Specifies whether or not the system user is permitted to submit standing requests when using job scheduler. Selecting the checkbox allows the system user to create standing requests.
ORG_ID NUMBER (15)
Operating unit identifier
Query Text

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


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERSON_ID
,      ENR_ACAD_CAL_TYPE
,      ENR_ACAD_SEQUENCE_NUMBER
,      ENR_ENROLMENT_CAT
,      ENR_ENR_METHOD_TYPE
,      ADM_ACAD_CAL_TYPE
,      ADM_ACAD_CI_SEQUENCE_NUMBER
,      ADM_ADM_CAL_TYPE
,      ADM_ADM_CI_SEQUENCE_NUMBER
,      ADM_ADMISSION_CAT
,      ADM_S_ADMISSION_PROCESS_TYPE
,      ENQ_ACAD_CAL_TYPE
,      ENQ_ACAD_CI_SEQUENCE_NUMBER
,      ENQ_ADM_CAL_TYPE
,      ENQ_ADM_CI_SEQUENCE_NUMBER
,      SERVER_PRINTER_DFLT
,      ALLOW_STND_REQ_IND
,      ORG_ID
FROM IGS.IGS_PE_PERS_PREFS_ALL;

Dependencies

[top of page]

IGS.IGS_PE_PERS_PREFS_ALL does not reference any database object

IGS.IGS_PE_PERS_PREFS_ALL is referenced by following:

SchemaAPPS
SynonymIGS_PE_PERS_PREFS_ALL