[Home] [Help] [Dependency Information]
Object Name: | IGS_DA_REQ_BATCH |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_DA_REQ_BATCH |
Subobject Name: | |
Status: | VALID |
Storage for Degree Audits on criteria for students in the request. --Obsolete
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_DA_REQ_BATCH_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Yes | ID to be in sync with parent request table IGS_DA_RQST | |
PERSON_ID_GROUP_CD | VARCHAR2 | (10) | User defined value in OSS for Person Group reference that links students on criteria meaningful to user | |
PERSON_ID_GROUP_ID | NUMBER | (6) | Unique identifier for the group id code created by the user for the Program Group Code | |
PERSON_ID_GROUP_DSCR | VARCHAR2 | (60) | Description of the Program Group Code meaningful to the user | |
CLASS_STANDING | VARCHAR2 | (50) | Student status based on user-defined criteria, usually the number of credits earned toward program completionExamples: freshman, sophomore, junior, senior, post-undergraduate | |
CLASS_STANDING_DSCR | VARCHAR2 | (60) | Description of the Class Standing meaningful to the user. | |
ADMISSION_OFFER_STATUS | VARCHAR2 | (10) | Status of institution's offer of admission to the applicant | |
ADMISSION_OFFR_DSCR | VARCHAR2 | (60) | Description of the Admission offer status meaningful to the user | |
S_ADM_OFFER_RESP_STAT | VARCHAR2 | (30) | System use for obtaining the admission offer status value | |
ADMISSION_PERIOD | VARCHAR2 | (30) | Calendar period which the applicant has applied for admission to the institution | |
ADM_PRD_CAL_TYPE | VARCHAR2 | (10) | Calendar type that is used in the definition of the admission period | |
ADM_PRD_SEQ_NUM | NUMBER | Sequence number for the calendar that is used in the definition of the admission period | ||
ADM_PRD_START_DT | DATE | Start date of the calendar instance that is used in definition of admission period | ||
ADM_PRD_END_DT | DATE | End date of the calendar instance that is used in definition of admission period | ||
ENTRY_STATUS | VARCHAR2 | (10) | Value indicating status of incoming student usually in terms of class standing at time of admissionExample:Early admit from High School, first time freshman, freshman transfer, junior transfer, post-undergraduate transfer | |
ENTRY_STATUS_DESC | VARCHAR2 | (60) | Description of the admission entry status meaningful to the user. | |
S_ADM_ENTRY_STATUS | VARCHAR2 | (30) | System use for obtaining the entry status value | |
PRIOR_INSTITUTION_CODE | VARCHAR2 | (60) | Institution id associated with the academic institutions attended by the student id of the request prior to being admitted to the local institution | |
PRIOR_INSTITUTION_NAME | VARCHAR2 | (360) | Name that identifies the institution code meaningful to the user. | |
ATHLETIC_PROGRAM_DESC | VARCHAR2 | (80) | Description of the athletic program meaningful to the user. | |
ATHLETIC_PROGRAM_NAME | VARCHAR2 | (30) | Name of the athletic program student is involved in | |
ATHLETIC_PROGRAM_ID | NUMBER | OBSOLETED. Unique identifier of the athletic program | ||
ADVISOR_PERSON_ID | NUMBER | Advisors person ID that matches the advisor_of name | ||
ADVISOR_OF | VARCHAR2 | (255) | Academic counselor to the student id of the request | |
ORGANIZATIONAL_UNIT_PROG | VARCHAR2 | (10) | Organizational unit associated with the student's program attempt identified in program/version belowExamples: College of Education, College of Business, Continuing Education Unit | |
ANTIC_COMPL_TERM | VARCHAR2 | (20) | Term that the student is anticipated to complete the program in | |
ANTIC_COMPL_CAL_TYPE | VARCHAR2 | (10) | Calendar type that the anticipated completion term is based off. | |
ANTIC_COMPL_SEQ_NUM | NUMBER | (6) | Sequence number for the calendar type that the anticipated completion term is based off | |
ANTIC_CAL_START_DATE | DATE | Anticipated Completion Term calendar start date | ||
ANTIC_CAL_END_DATE | DATE | Anticipated Completion Term calendar end date | ||
ANTIC_COMPL_OPER | VARCHAR2 | (30) | Operator value based on lookup of OPERATOR lookup type | |
GRAD_TERM | VARCHAR2 | (30) | Graduation term that the student is eligible for or potentially eligible for. | |
GRAD_CAL_TYPE | VARCHAR2 | (10) | Graduation term calendar type that assists in the creation the term | |
GRAD_SEQ_NUMBER | NUMBER | (6) | Graduation term calendar sequence number that assists in the creation of the term | |
GRAD_CAL_START_DT | DATE | Start date of the calendar instance that the Graduation term was created on | ||
GRAD_CAL_END_DT | DATE | End date of the calendar instance that the Graduation term was created on | ||
GRAD_TERM_OPER | VARCHAR2 | (30) | Operator value based on lookup of OPERATOR lookup type | |
PROGRAM_REF_CD | VARCHAR2 | (30) | Reference code value that is used for defining a program | |
PROGRAM_REF_CD_TYPE | VARCHAR2 | (10) | Program reference type value that identifies the reference code used for the program | |
PROGRAM_REF_CD_DESC | VARCHAR2 | (60) | Description of the reference code that is meaningful to the user. | |
S_REFERENCE_CD_TYPE | VARCHAR2 | (30) | System lookup for the program reference code. | |
PROGRAM_GROUP_CD | VARCHAR2 | (10) | Program code that represents the the group of programs | |
PROGRAM_GROUP_TYPE | VARCHAR2 | (10) | Program group type that represents the program code | |
PROGRAM_GROUP_DESC | VARCHAR2 | (60) | Description of the Program Group that is meaningful to the user. | |
PROGRAM_CD | VARCHAR2 | (6) | COURSE_CD associated with the student's program attempts | |
PROGRAM_TITLE | VARCHAR2 | (90) | Title of the Program that gives meaning to the user | |
PROGRAM_VERSION | NUMBER | (3) | version associated with COURSE_CD above | |
PROGRAM_ATTMPT_STATUS | VARCHAR2 | (30) | Status associated with program/version above | |
PROGRAM_CATALOG | VARCHAR2 | (30) | References date for program selection to identify the effective date(s) of the book which contains university-wide policy applicable to student progression and academic decision-making rules Examples: Academic Yr 2000 Academic Yr plus Term 1999 Spring | |
PROGRAM_CATALOG_OPER | VARCHAR2 | (30) | Greater than, less than, equal to value for program catalog | |
PROGRAM_CAT_CAL_TYPE | VARCHAR2 | (10) | Calendar type to the program catalog | |
PROGRAM_CAT_SEQ_NUM | NUMBER | (6) | Sequence number associated to the calendar for the program catalog | |
PROGRAM_CAT_START_DT | DATE | Start date of the Program Catalog | ||
PROGRAM_CAT_END_DT | DATE | End Date of the program Catalog | ||
UNIT_SET_CATEGORY | VARCHAR2 | (10) | Type of unit setExamples: major, minor | |
UNIT_SET_CAT_DESC | VARCHAR2 | (60) | Description of the Unit Set category that is meaningful to the user. | |
UNIT_SET_CODE | VARCHAR2 | (10) | Unit set's reference value which has meaning to the user or third party software | |
UNIT_SET_CODE_TITLE | VARCHAR2 | (90) | Unit Sets title for the Unit set code | |
UNIT_SET_VERSION | NUMBER | (3) | Version number of the unit set code | |
UNIT_SET_CATALOG | VARCHAR2 | (30) | References date for unit set selection to identify the effective date(s) of the book which contains university-wide policy applicable to student progression and academic decision-making rules Examples: Academic Yr 2000 Academic Yr plus Term 1999 Spring | |
UNIT_SET_CATALOG_OPER | VARCHAR2 | (2) | Greater than, less than, equal to value for unit set catalog | |
UNIT_SET_CAT_CAL_TYPE | VARCHAR2 | (10) | Calendar type that is associated to the catalog term | |
UNIT_SET_CAT_SEQ_NUM | NUMBER | (6) | Sequence number that is associated to the calendar to make up the catalog term | |
UNIT_SET_CAT_START_DT | DATE | Start date of the Unit Set catalog | ||
UNIT_SET_CAT_END_DT | DATE | End date of the unit set catalog | ||
ACADEMIC_TERM | VARCHAR2 | (30) | Timeframe that a unit was taught at the institution | |
ACAD_CAL_TYPE | VARCHAR2 | (10) | Calendar Type which assists in the defining of the academic term | |
ACAD_SEQ_NUM | NUMBER | Sequence number for the calendar instance that assists in defining the academic term | ||
ACAD_TERM_START_DT | DATE | Start date of the academic term | ||
ACAD_TERM_END_DT | DATE | End date of the academic term | ||
UNIT_REF_CODE | VARCHAR2 | (30) | Reference value associated with unit_code/versions which has meaning to the userExample: - SocSci meaning unit allowed to meet Social Science general education requirements- MajElect meaning unit which is allowed to meet Major Elective requirments | |
UNIT_REF_CD_TYPE | VARCHAR2 | (10) | Type of reference code for the Unit. | |
UNIT_REF_CD_DESC | VARCHAR2 | (60) | Description of the Reference code meaningful to the user for the unit | |
S_UNIT_REF_CD_TYPE | VARCHAR2 | (30) | System defined valueto be used for matching Student Ids to the Unit Reference cd Type | |
UNIT_SECTN_REF_CODE | VARCHAR2 | (30) | Reference value associated with unit code/version's unit class which has meaning to the user Examples: - MechEngr meaning Independent Study in Engineering applicable to Mechanical Engineering- ElecEngr meaning Independent Study in Engineering applicable to Electrical Engineering | |
UNIT_SECTN_REF_CD_DESC | VARCHAR2 | (60) | Description of the reference code meaningful to the user for the unit section | |
UNIT_SECTN_REF_CD_TYPE | VARCHAR2 | (10) | Type of reference code for the unit section | |
S_UNIT_SEC_REF_CD_TYPE | VARCHAR2 | (30) | System defined valueto be used for matching Student Ids to the Unit Section Reference cd | |
CUM_GPA | NUMBER | (6) | Cumulative value which represents ability of student id in the request to achieve academically at the institution. May include all units attempted by the student. Examples: (4.00 Scale)Cum GPA = 4.00 ExcellentCum GPA = 3.00 GoodCum GPA = 1.50 Poor | |
CUM_GPA_OPER | VARCHAR2 | (30) | Greater than, less than, equal to value for cum gpa | |
CUM_CREDIT_PTS | NUMBER | Cumulative Credit points | ||
CUM_CREDIT_PTS_OPER | VARCHAR2 | (30) | Selection of Lookup value from OPERATOR lookup type based on LOV for greater than, less than, or equal to. | |
TEST_TYPE | VARCHAR2 | (10) | Type of TestExamples:SAT, ACT, GRE, TOEFL, User-defined performance or placement tests | |
TEST_TYPE_DESC | VARCHAR2 | (60) | Description of the test type that is meaningful to the user. | |
COMPOSITE_TEST_SCORE | NUMBER | Summary of scores for component segments of the test score type aboveExample: The composite test score for ACT would include the summary of scores for English, Math, Science, and other test segments associated with the ACT test | ||
COMPOSITE_TEST_SCORE_OPER | VARCHAR2 | (30) | Greater than, less than, equal to value for composite test score | |
TEST_SEGMENT_NAME | VARCHAR2 | (30) | Name of sub-test associated with test score type above | |
TEST_SEGMENT_DESC | VARCHAR2 | (80) | Description of the test segment meaningful to the user. | |
TEST_SEGMENT_SCORE | NUMBER | Score received for each sub-test of test score type above | ||
TEST_SEGMENT_SCORE_OPER | VARCHAR2 | (30) | Greater than, less than, equal to value for test segment score | |
SORT_OPTION1 | VARCHAR2 | (3) | Primary value to sort students selected for the batch request. Affects order student id loaded to outgoing data exchange tables. | |
SORT_OPTION2 | VARCHAR2 | (3) | Secondary value to sort students selected for the batch request. Affects order student id loaded to outgoing data exchange tables. | |
SORT_OPTION3 | VARCHAR2 | (3) | Third value to sort students selected for the batch request. Affects order student id loaded to outgoing data exchange tables. | |
SORT_OPTION4 | VARCHAR2 | (3) | Fourth value to sort students selected for the batch request. Affects order student id loaded to outgoing data exchange tables. | |
SORT_OPTION5 | VARCHAR2 | (3) | Fifth value to sort students selected for the batch request. Affects order student id loaded to outgoing data exchange tables. | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PERSON_ID_GROUP_CD
, PERSON_ID_GROUP_ID
, PERSON_ID_GROUP_DSCR
, CLASS_STANDING
, CLASS_STANDING_DSCR
, ADMISSION_OFFER_STATUS
, ADMISSION_OFFR_DSCR
, S_ADM_OFFER_RESP_STAT
, ADMISSION_PERIOD
, ADM_PRD_CAL_TYPE
, ADM_PRD_SEQ_NUM
, ADM_PRD_START_DT
, ADM_PRD_END_DT
, ENTRY_STATUS
, ENTRY_STATUS_DESC
, S_ADM_ENTRY_STATUS
, PRIOR_INSTITUTION_CODE
, PRIOR_INSTITUTION_NAME
, ATHLETIC_PROGRAM_DESC
, ATHLETIC_PROGRAM_NAME
, ATHLETIC_PROGRAM_ID
, ADVISOR_PERSON_ID
, ADVISOR_OF
, ORGANIZATIONAL_UNIT_PROG
, ANTIC_COMPL_TERM
, ANTIC_COMPL_CAL_TYPE
, ANTIC_COMPL_SEQ_NUM
, ANTIC_CAL_START_DATE
, ANTIC_CAL_END_DATE
, ANTIC_COMPL_OPER
, GRAD_TERM
, GRAD_CAL_TYPE
, GRAD_SEQ_NUMBER
, GRAD_CAL_START_DT
, GRAD_CAL_END_DT
, GRAD_TERM_OPER
, PROGRAM_REF_CD
, PROGRAM_REF_CD_TYPE
, PROGRAM_REF_CD_DESC
, S_REFERENCE_CD_TYPE
, PROGRAM_GROUP_CD
, PROGRAM_GROUP_TYPE
, PROGRAM_GROUP_DESC
, PROGRAM_CD
, PROGRAM_TITLE
, PROGRAM_VERSION
, PROGRAM_ATTMPT_STATUS
, PROGRAM_CATALOG
, PROGRAM_CATALOG_OPER
, PROGRAM_CAT_CAL_TYPE
, PROGRAM_CAT_SEQ_NUM
, PROGRAM_CAT_START_DT
, PROGRAM_CAT_END_DT
, UNIT_SET_CATEGORY
, UNIT_SET_CAT_DESC
, UNIT_SET_CODE
, UNIT_SET_CODE_TITLE
, UNIT_SET_VERSION
, UNIT_SET_CATALOG
, UNIT_SET_CATALOG_OPER
, UNIT_SET_CAT_CAL_TYPE
, UNIT_SET_CAT_SEQ_NUM
, UNIT_SET_CAT_START_DT
, UNIT_SET_CAT_END_DT
, ACADEMIC_TERM
, ACAD_CAL_TYPE
, ACAD_SEQ_NUM
, ACAD_TERM_START_DT
, ACAD_TERM_END_DT
, UNIT_REF_CODE
, UNIT_REF_CD_TYPE
, UNIT_REF_CD_DESC
, S_UNIT_REF_CD_TYPE
, UNIT_SECTN_REF_CODE
, UNIT_SECTN_REF_CD_DESC
, UNIT_SECTN_REF_CD_TYPE
, S_UNIT_SEC_REF_CD_TYPE
, CUM_GPA
, CUM_GPA_OPER
, CUM_CREDIT_PTS
, CUM_CREDIT_PTS_OPER
, TEST_TYPE
, TEST_TYPE_DESC
, COMPOSITE_TEST_SCORE
, COMPOSITE_TEST_SCORE_OPER
, TEST_SEGMENT_NAME
, TEST_SEGMENT_DESC
, TEST_SEGMENT_SCORE
, TEST_SEGMENT_SCORE_OPER
, SORT_OPTION1
, SORT_OPTION2
, SORT_OPTION3
, SORT_OPTION4
, SORT_OPTION5
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM IGS.IGS_DA_REQ_BATCH;
IGS.IGS_DA_REQ_BATCH does not reference any database object
IGS.IGS_DA_REQ_BATCH is referenced by following:
|
|
|