[Home] [Help] [Dependency Information]
Object Name: | IGS_AD_RECRUIT_INT |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AD_RECRUIT_INT |
Subobject Name: | |
Status: | VALID |
Contains Recruitment details to be imported into the IGS_AD_RECRUITMENTS table by the Admission Import process.
Scope: public
Product: IGS
Lifecycle: active
Display Name: Import Recruitment Detail
Category: BUSINESS_ENTITY IGS_INQ_APPLICATION
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AD_RECRUIT_INT_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE | INTERFACE_RECRUITMENT_ID |
IGS_AD_RECRUIT_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_ID |
IGS_AD_RECRUIT_INT_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | STATUS |
IGS_AD_RECRUIT_INT_N3 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_RUN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_RECRUITMENT_ID | NUMBER | (15) | Yes | Unique identifier of recruitment details record |
INTERFACE_ID | NUMBER | (15) | Yes | Interface identifier |
DUP_RECRUITMENT_ID | NUMBER | (15) | Duplicate recruitment record | |
SPECIAL_INTEREST_ID | NUMBER | (15) | Person's special interest identifier | |
PRIORITY | VARCHAR2 | (20) | Priority of the recruit | |
PROBABILITY | NUMBER | (3) | Probability of enrollment | |
VIP | VARCHAR2 | (1) | Very important person | |
DEACTIVATE_RECRUIT_STATUS | VARCHAR2 | (1) | Deactivate recruit status | |
PROGRAM_INTEREST_ID | NUMBER | (15) | Recruit program interest | |
INSTITUTION_SIZE_ID | NUMBER | (15) | Desired institution size | |
INSTITUTION_CONTROL_ID | NUMBER | (15) | Desired institution control | |
INSTITUTION_SETTING_ID | NUMBER | (15) | Desired institution setting | |
INSTITUTION_LOCATION_ID | NUMBER | (15) | Desired institution location | |
SPECIAL_SERVICES_ID | NUMBER | (15) | Desired special services | |
EMPLOYMENT_ID | NUMBER | (15) | Desired employment | |
HOUSING_ID | NUMBER | (15) | Desired housing | |
DEGREE_GOAL_ID | NUMBER | (15) | Desired degree goal | |
UNIT_SET_ID | NUMBER | (15) | Desired unit set | |
CERTAINTY_OF_CHOICE_ID | NUMBER | (15) | Certainty of choice of unit set | |
ADV_STUDIES_CLASSES | NUMBER | Number of advanced studies classes offered | ||
HONORS_CLASSES | NUMBER | Number of honors classes offered | ||
CLASS_SIZE | NUMBER | Class size | ||
SEC_SCHOOL_LOCATION_ID | NUMBER | (15) | Secondary school location | |
PERCENT_PLAN_HIGHER_EDU | NUMBER | (3) | Percent Planning to pursue higher education | |
MATCH_IND | VARCHAR2 | (2) | Match indicator | |
STATUS | VARCHAR2 | (1) | Yes | 1-Completed 2- Pending 3-Error 4-Warning |
ERROR_CODE | VARCHAR2 | (30) | Error code | |
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) | Standard Who column for concurrent programs | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs | ||
RELIGION_CD | VARCHAR2 | (30) | Religion code | |
INTERFACE_RUN_ID | NUMBER | Unique identifier to associate the interface record processing with an instance of the Import Process Run. This column will be populated by the Logic in the Import process, and should not be populated by the user | ||
PERSON_ID | NUMBER | (15) | Person Identifier. This column will be populated by the import process. | |
ERROR_TEXT | VARCHAR2 | (2000) | Error Text |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_RECRUITMENT_ID
, INTERFACE_ID
, DUP_RECRUITMENT_ID
, SPECIAL_INTEREST_ID
, PRIORITY
, PROBABILITY
, VIP
, DEACTIVATE_RECRUIT_STATUS
, PROGRAM_INTEREST_ID
, INSTITUTION_SIZE_ID
, INSTITUTION_CONTROL_ID
, INSTITUTION_SETTING_ID
, INSTITUTION_LOCATION_ID
, SPECIAL_SERVICES_ID
, EMPLOYMENT_ID
, HOUSING_ID
, DEGREE_GOAL_ID
, UNIT_SET_ID
, CERTAINTY_OF_CHOICE_ID
, ADV_STUDIES_CLASSES
, HONORS_CLASSES
, CLASS_SIZE
, SEC_SCHOOL_LOCATION_ID
, PERCENT_PLAN_HIGHER_EDU
, MATCH_IND
, STATUS
, ERROR_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, RELIGION_CD
, INTERFACE_RUN_ID
, PERSON_ID
, ERROR_TEXT
FROM IGS.IGS_AD_RECRUIT_INT;
IGS.IGS_AD_RECRUIT_INT does not reference any database object
IGS.IGS_AD_RECRUIT_INT is referenced by following:
|
|
|