[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_REQD_FIELDS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_SL_REQD_FIELDS |
Subobject Name: | |
Status: | VALID |
IGF_SL_REQD_FIELDS stores the fields that are mandatory for processing the loan. This is mainly used in the validation process while checking whether the value is present for each of the fields sent to the external processor.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_SL_REQD_FIELDS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | LRF_ID |
IGF_SL_REQD_FIELDS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
SPEC_VERSION
FIELD_NAME LOAN_TYPE TRANSACTION_TYPE PRC_TYPE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LRF_ID | NUMBER | (15) | Yes | Unique identifier |
SPEC_VERSION | VARCHAR2 | (30) | Yes | Identifies version of loan file specifiication. Examples of values for Direct Loans are 2001-2002 and 2002-2003, and examples for CommonLine loans are RELEASE-5 and RELEASE-6. |
FIELD_NAME | VARCHAR2 | (28) | Yes | Indicates database field name |
LOAN_TYPE | VARCHAR2 | (30) | Yes | Indicates type of loan, such as DLS, DLU, DLP, FLS, FLP, or ALT |
TRANSACTION_TYPE | VARCHAR2 | (10) | Indicates transaction type used in CommonLine. Can be null for Direct Loan records. | |
PRC_TYPE_CODE | VARCHAR2 | (30) | Contains processing types for loan. Used by CommonLine loans. Examples of valuse are GO, GP, PG, DISB, PO, or NA. | |
STATUS | VARCHAR2 | (30) | Yes | Indicates whether processing is mandatory. Examples of values are required, strongly recommended, and optional. Processing stops for this loan only if field value is not present for R fields. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT LRF_ID
, SPEC_VERSION
, FIELD_NAME
, LOAN_TYPE
, TRANSACTION_TYPE
, PRC_TYPE_CODE
, STATUS
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGF.IGF_SL_REQD_FIELDS;
IGF.IGF_SL_REQD_FIELDS does not reference any database object
IGF.IGF_SL_REQD_FIELDS is referenced by following:
|
|
|