[Home] [Help]
View: IGS_HE_EX_RN_FD_LN_DTLS_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Links Extract Lines with Extract Fields |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT A.ROWID
, A.RN_DAT_FD_ID
, A.EXTRACT_RUN_ID
, A.FIELD_NUMBER
, A.LINE_NUMBER
, B.PERSON_ID
, B.STUDENT_INST_NUMBER
, B.COURSE_CD
, B.CRV_VERSION_NUMBER
, B.UNIT_CD
, B.UV_VERSION_NUMBER
, A.VALUE
, A.OVERRIDE_VALUE
, B.MANUALLY_INSERTED
, B.EXCLUDE_FROM_FILE
, B.RECALCULATE_FLAG
FROM IGS_HE_EX_RN_DAT_FD A
, IGS_HE_EX_RN_DAT_LN B
WHERE A.EXTRACT_RUN_ID = B.EXTRACT_RUN_ID
AND A.LINE_NUMBER = B.LINE_NUMBER
Columns
| Name |
| ROW_ID |
| RN_DAT_FD_ID |
| EXTRACT_RUN_ID |
| FIELD_NUMBER |
| LINE_NUMBER |
| PERSON_ID |
| STUDENT_INST_NUMBER |
| COURSE_CD |
| CRV_VERSION_NUMBER |
| UNIT_CD |
| UV_VERSION_NUMBER |
| VALUE |
| OVERRIDE_VALUE |
| MANUALLY_INSERTED |
| EXCLUDE_FROM_FILE |
| RECALCULATE_FLAG |