[Home] [Help] [Dependency Information]
Object Name: | IGSFV_AD_PER_TST_RSLT_DTLS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSFV_AD_PER_TST_RSLT_DTLS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TST_RSLT_DTLS_ID | NUMBER | (15) | Yes | Unique identifier that identifies the test segments for a test |
TEST_RESULTS_ID | NUMBER | (15) | Yes | Unique identifier that identifies the test results |
PERSON_ID | NUMBER | (15) | Yes | Person for whom the test results is stored |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
PERSON_NAME | VARCHAR2 | (450) | Person name | |
ADMISSION_TEST_TYPE | VARCHAR2 | (30) | Yes | Admission Test Type |
ADMISSION_TEST_TYPE_DESC | VARCHAR2 | (60) | Yes | Admission Test Type Description |
ADMISSION_TEST_DATE | DATE | Yes | Date on which the test was administered | |
TEST_SEGMENT_ID | NUMBER | (15) | Yes | Unique identifier that identifies a test segment |
TEST_SEGMENT_NAME | VARCHAR2 | (30) | Yes | Test segment name |
TEST_SCORE | NUMBER | Test score for this test segment | ||
TEST_SCORE_PERCENTILE | NUMBER | Test score percentile | ||
NATIONAL_PERCENTILE | NUMBER | Score percentile of national pool of test takers | ||
STATE_PERCENTILE | NUMBER | Score percentile of state pool of test takers | ||
PERCENTILE_YEAR_RANK | NUMBER | Percentile year rank | ||
SCORE_BAND_LOWER | NUMBER | Score band lower | ||
SCORE_BAND_UPPER | NUMBER | Score band upper | ||
IRREGULARITY_CODE_ID | NUMBER | (15) | Any irregularity associated with the test conducted like data cancelled, candidate being absent or delayed in taking the test, candidate canceling the test. | |
IRREGULARITY_CODE_NAME | VARCHAR2 | (10) | Irregularity code name | |
_DF | CHAR | (38) | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT TST_RSLT_DTLS_ID
, TEST_RESULTS_ID
, PERSON_ID
, PERSON_NUMBER
, PERSON_NAME
, ADMISSION_TEST_TYPE
, ADMISSION_TEST_TYPE_DESC
, ADMISSION_TEST_DATE
, TEST_SEGMENT_ID
, TEST_SEGMENT_NAME
, TEST_SCORE
, TEST_SCORE_PERCENTILE
, NATIONAL_PERCENTILE
, STATE_PERCENTILE
, PERCENTILE_YEAR_RANK
, SCORE_BAND_LOWER
, SCORE_BAND_UPPER
, IRREGULARITY_CODE_ID
, IRREGULARITY_CODE_NAME
, _DF
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGSFV_AD_PER_TST_RSLT_DTLS;
APPS.IGSFV_AD_PER_TST_RSLT_DTLS is not referenced by any database object
|
|
|