[Home] [Help] [Dependency Information]
Object Name: | BIL_DIMV_QUALIFICATIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIL.BIL_DIMV_QUALIFICATIONS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | Person identifier | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Business group | |
PERSON_NAME | VARCHAR2 | (240) | Current person name | |
QUALIFICATION_TITLE | VARCHAR2 | (120) | Title of qualification | |
GRADE_ATTAINED | VARCHAR2 | (100) | Grade person holds qualification | |
QUALIFICATION_STATUS | VARCHAR2 | (4000) | Status of qualification, for example, whether training is ongoing or completed | |
AWARDED_DATE | DATE | Date qualification awarded | ||
FEE | NUMBER | Tuition fee amount that the person will be reimbursed | ||
FEE_CURRENCY | VARCHAR2 | (80) | Currency of the tuition fee | |
TRAINING_COMPLETED_AMOUNT | NUMBER | Amount of training completed, for example, 30 days completed of a training program that lasts 60 days, see also TRAINING_COMPLETED_UNITS and TOTAL_TRAINING_AMOUNT | ||
REIMBURSEMENT_ARRANGEMENTS | VARCHAR2 | (2000) | Arrangement by which tuition fees are reimbursed, for example, bank transfer to be paid when qualification is awarded | |
TOTAL_TRAINING_AMOUNT | NUMBER | Total amount of training to be completed, see also TRAINING_COMPLETED_UNITS and TRAINING_COMPLETED_AMOUNT | ||
TRAINING_COMPLETED_UNITS | VARCHAR2 | (100) | Units of TRAINING COMPLETED AMOUNT and TOTAL TRAINING AMOUNT | |
QUALIFICATION_START_DATE | DATE | Date training for qualification commenced | ||
QUALIFICATION_END_DATE | DATE | Date training for the qualification finished | ||
LICENSE_NUMBER | VARCHAR2 | (80) | License number associated with the qualification, for example, a driving licence number. | |
LICENSE_EXPIRY_DATE | DATE | Expiry date of the license associated with the qualification | ||
LICENSE_RESTRICTIONS | VARCHAR2 | (255) | Restrictions on license associated with the qualification, for example, a driving license might only be valid in certain states | |
PROJECTED_COMPLETION_DATE | DATE | Projected completion date of qualification training | ||
AWARDING_BODY | VARCHAR2 | (100) | Awarding body for qualification | |
METHOD_OF_REIMBURSEMENT | VARCHAR2 | (4000) | Method of reimbursement for training | |
GROUP_RANKING | VARCHAR2 | (100) | Group ranking for training | |
COMMENTS | VARCHAR2 | (2000) | Comments for qualification | |
SCHOOL_OR_COLLEGE_NAME | VARCHAR2 | (255) | School or college name | |
QUALIFICATION_CATEGORY | VARCHAR2 | (4000) | Qualification category | |
QUALIFICATION_TYPE_NAME | VARCHAR2 | (150) | Qualification type | |
BUSINESS_GROUP_ID | NUMBER | |||
SCHOOL_OR_COLLEGE_ID | NUMBER | |||
QUALIFICATION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, BUSINESS_GROUP_NAME
, PERSON_NAME
, QUALIFICATION_TITLE
, GRADE_ATTAINED
, QUALIFICATION_STATUS
, AWARDED_DATE
, FEE
, FEE_CURRENCY
, TRAINING_COMPLETED_AMOUNT
, REIMBURSEMENT_ARRANGEMENTS
, TOTAL_TRAINING_AMOUNT
, TRAINING_COMPLETED_UNITS
, QUALIFICATION_START_DATE
, QUALIFICATION_END_DATE
, LICENSE_NUMBER
, LICENSE_EXPIRY_DATE
, LICENSE_RESTRICTIONS
, PROJECTED_COMPLETION_DATE
, AWARDING_BODY
, METHOD_OF_REIMBURSEMENT
, GROUP_RANKING
, COMMENTS
, SCHOOL_OR_COLLEGE_NAME
, QUALIFICATION_CATEGORY
, QUALIFICATION_TYPE_NAME
, BUSINESS_GROUP_ID
, SCHOOL_OR_COLLEGE_ID
, QUALIFICATION_ID
FROM APPS.BIL_DIMV_QUALIFICATIONS;
APPS.BIL_DIMV_QUALIFICATIONS is not referenced by any database object
|
|
|