[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGSFV_ADVISING_GROUPS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGSFV_ADVISING_GROUPS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Stores advising group definition
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ADVISING_GROUP_NAME | VARCHAR2 | (90) | Yes | Primary Key Name of the Advising Group |
| GROUP_DESCRIPTION | VARCHAR2 | (240) | Yes | A short description of the Advising Group |
| ADVISING_CATEGORY | VARCHAR2 | (30) | User defined advising category that is used as a means to cluster advising groups e.g. Academic Advising Groups, Administrative Advising Groups, Athletic Advising groups, etc. | |
| _LA:ADVISING_CATEGORY_DESC | CHAR | (64) | Advising Category description | |
| RESP_ORG_UNIT_CODE | VARCHAR2 | (30) | Yes | Responsible organization code |
| RESP_PERSON_IDENTIFIER | NUMBER | (15) | Person id of the person responsible for this group | |
| DELIVERY_METHOD_CODE | VARCHAR2 | (30) | Yes | The type of the advising group such as 1-on-1 etc |
| _LA:DELIVERY_MTH_CODE_DESC | CHAR | (70) | The description of the delivery method for this group | |
| ADVISOR_GROUP_ID | NUMBER | Advisor's Person ID Group (PIG) associated with the Advising group. The PIG could be static or dynamic. | ||
| STUDENT_GROUP_ID | NUMBER | Student's Person ID Group (PIG) associated with the Advising group. The PIG could be static or dynamic | ||
| DEFAULT_ADVISOR_LOAD | NUMBER | The default number of Students an Advisor is expected to counsel in an advising group. This number can be overwritten for each advisor assigned to the group. | ||
| MANDATORY_FLAG | VARCHAR2 | (1) | Yes | If selected, the system will track to ensure that students meet their respective advisor(s) at least as many times as stated in the "Advising Sessions" field |
| ADVISING_SESSIONS | NUMBER | Expected number of times a student is expected to meet an Advisor | ||
| ADVISING_HOLD_TYPE | VARCHAR2 | (10) | If selected, all students associated with the advising group will be required to be put on a "hold" with the selected Advising Hold Type | |
| CLOSED_FLAG | VARCHAR2 | (1) | Yes | If selected the checkbox signifies that the group is "inactive" |
| COMMENTS | VARCHAR2 | (2000) | Free form text field to allow user enter more specific information about the group definition e.g. the types of students, advisors expected to be part of the advising group, etc. | |
| AUTO_REFRESH_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the advising group will be selected for periodic run of the maintenance job. If selected, the advising group will be included in the periodic run of the "Maintain Advising Group" concurrent manager job. |
| LAST_AUTO_REFRESH_DATE | DATE | Indicates whether the advising group will be selected for periodic run of the maintenance job. If selected, the advising group will be included in the periodic run of the "Maintain Advising Group" concurrent manager job. | ||
| AUTO_STDNT_ADD_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Student Additions will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_STDNT_REMOVE_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Student Removals will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_ADVISOR_ADD_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Advisor Additions will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_ADVISOR_REMOVE_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Advisor Removals will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_MATCH_FLAG | VARCHAR2 | (1) | Yes | If selected, the suggested Advisor and Student matches will be automatically confirmed by the "Maintain Advising Group" concurrent manager job |
| AUTO_APPLY_HOLD_FLAG | VARCHAR2 | (1) | Yes | If selected the "Apply Advising Hold" concurrent manager job, during its periodic run, will put all eligible students on an "advising hold" |
| LOCATION_CODE | VARCHAR2 | (10) | Location of the Advising Center of an advising group | |
| _DF | CHAR | (30) | ||
| 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 | |
| RESP_PERSON_NUMBER | VARCHAR2 | (30) | Person number of the person responsible for this group | |
| RESP_ORGANIZATION | VARCHAR2 | (360) | Yes | Responsible organization code |
| LOCATION_DESC | VARCHAR2 | (60) | Location of this group where advising will be conducted | |
| _LA:MANDATORY_FLAG_DESC | CHAR | (51) | Description of the Mandatory flag. | |
| _LA:CLOSED_FLAG_DESC | CHAR | (48) | Description of the closed flag. | |
| _LA:AUTO_REFRESH_FLAG_DESC | CHAR | (54) | Description of the auto refreshes flag. | |
| _LA:AUTO_STDNT_ADD_FLAG_DESC | CHAR | (56) | Description of the auto student adds flag. | |
| _LA:AUTO_STDNT_RMV_FLAG_DESC | CHAR | (59) | Description of the auto student removes flag. | |
| _LA:AUTO_ADVSOR_ADD_FLG_DESC | CHAR | (58) | Description of the auto advisor adds flag. | |
| _LA:AUTO_ADVSR_RMV_FLAG_DESC | CHAR | (61) | Description of the auto advisor removes flag. | |
| _LA:AUTO_MATCH_FLAG_DESC | CHAR | (52) | Description of the auto match flag | |
| _LA:AUTO_APPLY_HLD_FLAG_DESC | CHAR | (57) | Description of the auto holds flag. | |
| HOLD_DESC | VARCHAR2 | (60) | Advising Hold Type | |
| STUDENT_GROUP_DESCRIPTION | VARCHAR2 | (60) | Group Description of the Student | |
| ADVISOR_GROUP_DESCRIPTION | VARCHAR2 | (60) | Advisor Group Description |
Cut, paste (and edit) the following text to query this object:
SELECT ADVISING_GROUP_NAME
, GROUP_DESCRIPTION
, ADVISING_CATEGORY
, _LA:ADVISING_CATEGORY_DESC
, RESP_ORG_UNIT_CODE
, RESP_PERSON_IDENTIFIER
, DELIVERY_METHOD_CODE
, _LA:DELIVERY_MTH_CODE_DESC
, ADVISOR_GROUP_ID
, STUDENT_GROUP_ID
, DEFAULT_ADVISOR_LOAD
, MANDATORY_FLAG
, ADVISING_SESSIONS
, ADVISING_HOLD_TYPE
, CLOSED_FLAG
, COMMENTS
, AUTO_REFRESH_FLAG
, LAST_AUTO_REFRESH_DATE
, AUTO_STDNT_ADD_FLAG
, AUTO_STDNT_REMOVE_FLAG
, AUTO_ADVISOR_ADD_FLAG
, AUTO_ADVISOR_REMOVE_FLAG
, AUTO_MATCH_FLAG
, AUTO_APPLY_HOLD_FLAG
, LOCATION_CODE
, _DF
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, RESP_PERSON_NUMBER
, RESP_ORGANIZATION
, LOCATION_DESC
, _LA:MANDATORY_FLAG_DESC
, _LA:CLOSED_FLAG_DESC
, _LA:AUTO_REFRESH_FLAG_DESC
, _LA:AUTO_STDNT_ADD_FLAG_DESC
, _LA:AUTO_STDNT_RMV_FLAG_DESC
, _LA:AUTO_ADVSOR_ADD_FLG_DESC
, _LA:AUTO_ADVSR_RMV_FLAG_DESC
, _LA:AUTO_MATCH_FLAG_DESC
, _LA:AUTO_APPLY_HLD_FLAG_DESC
, HOLD_DESC
, STUDENT_GROUP_DESCRIPTION
, ADVISOR_GROUP_DESCRIPTION
FROM APPS.IGSFV_ADVISING_GROUPS;
APPS
HZ_PARTIES
IGS_AD_LOCATION_ALL
IGS_AZ_GROUPS
IGS_FI_ENCMB_TYPE_ALL
IGS_PE_HZ_PARTIES
IGS_PE_PERSID_GROUP_ALL
APPS.IGSFV_ADVISING_GROUPS is not referenced by any database object
|
|
|
|