DBA Data[Home] [Help] [Dependency Information]

TABLE: IGF.IGF_SL_DL_FILE_TYPE

Object Details
Object Name: IGF_SL_DL_FILE_TYPE
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_SL_DL_FILE_TYPE
Subobject Name:
Status: VALID


IGF_SL_DL_FILE_TYPE contains the mapping from file specification version number to message class and batch identifier.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_DL_FILE_TYPE_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDL_VERSION
ColumnDL_FILE_TYPE
ColumnDL_LOAN_CATG
Columns
Name Datatype Length Mandatory Comments
DL_VERSION VARCHAR2 (30) Yes Indicates Direct Loan version number for file
DL_FILE_TYPE VARCHAR2 (30) Yes Indicates file type. Values are Direct Loan origination send file, Direct Loan origination acknowledgement file, Direct Loan change send file, or Direct Loan change acknowledgement file.
DL_LOAN_CATG VARCHAR2 (30) Yes Indicates loan category in file
MESSAGE_CLASS VARCHAR2 (30)
Indicates message class file name as recognized by LOC
BATCH_TYPE VARCHAR2 (30)
Indicates batch type as specified for each file
CYCLE_YEAR VARCHAR2 (30)
Indicates year
REC_LENGTH NUMBER (15)
Indicates record length for file
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DL_VERSION
,      DL_FILE_TYPE
,      DL_LOAN_CATG
,      MESSAGE_CLASS
,      BATCH_TYPE
,      CYCLE_YEAR
,      REC_LENGTH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_DL_FILE_TYPE;

Dependencies

[top of page]

IGF.IGF_SL_DL_FILE_TYPE does not reference any database object

IGF.IGF_SL_DL_FILE_TYPE is referenced by following:

SchemaAPPS
SynonymIGF_SL_DL_FILE_TYPE