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

TABLE: IGF.IGF_SL_CLCHSN_DTLS

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


Stores all the change records for Loan record for CommonLine Release 4 Version


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_SL_CLCHSN_DTLS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCLCHGSND_ID
IGF_SL_CLCHSN_DTLS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSEND_RECORD_TXT
Columns
Name Datatype Length Mandatory Comments
CLCHGSND_ID NUMBER
Yes Sequence generated primary key
AWARD_ID NUMBER
Yes Award ID
LOAN_NUMBER_TXT VARCHAR2 (30) Yes Loan Number
CL_VERSION_CODE VARCHAR2 (30) Yes CommonLine Version Code
CHANGE_FIELD_CODE VARCHAR2 (30) Yes Change Field Name
CHANGE_RECORD_TYPE_TXT VARCHAR2 (30) Yes Change Record Type
CHANGE_CODE_TXT VARCHAR2 (30) Yes Change Code
STATUS_CODE VARCHAR2 (1) Yes Internal Change Status Flag - Ready to Send, Sent, Not Ready, Acknowledged, Do not Send
STATUS_DATE DATE
Yes Date when the Change Status flag is set
RESPONSE_STATUS_CODE VARCHAR2 (30)
Response Status Code - Accepted, Rejected or Duplicate
OLD_VALUE_TXT VARCHAR2 (30)
Old value of the changed field
NEW_VALUE_TXT VARCHAR2 (30)
New value of the changed field
OLD_DATE DATE

Old value of the changed field of Date Type
NEW_DATE DATE

New value of the changed field of Date Type
OLD_AMT NUMBER

Old value of the changed field of Number Type
NEW_AMT NUMBER

New value of the changed field of Number Type
DISBURSEMENT_NUMBER NUMBER

Disbursement Number
DISBURSEMENT_DATE DATE

Disbursement Date
CHANGE_ISSUE_CODE VARCHAR2 (30)
Pre-Disbursement or Post-Disbursement change
DISBURSEMENT_CANCEL_DATE DATE

Disbursement Cancel Date
DISBURSEMENT_CANCEL_AMT NUMBER

Disbursement Cancel Amount
DISBURSEMENT_REVISED_AMT NUMBER (15)
Disbursement Revised Amount
DISBURSEMENT_REVISED_DATE DATE

Disbursement Revised Date
DISBURSEMENT_REISSUE_CODE VARCHAR2 (30)
Full or Partial Disbursement Re-issue
DISBURSEMENT_REINST_CODE VARCHAR2 (30)
Disbursement Re-instatement, Yes or No
DISBURSEMENT_RETURN_AMT NUMBER (15)
Disbursement Return Amount
DISBURSEMENT_RETURN_DATE DATE

Disbursement Return Date
DISBURSEMENT_RETURN_CODE VARCHAR2 (30)
Disbursement Return Method Code
POST_WITH_DISB_RETURN_AMT NUMBER

Post Withdrawal Disbursement Return Amount, for future use.
POST_WITH_DISB_RETURN_DATE DATE

Post Withdrawal Disbursement Return Date, for future use
POST_WITH_DISB_RETURN_CODE VARCHAR2 (30)
Post Withdrawal Disbursement Return Method Code, for future use.
PREV_WITH_DISB_RETURN_AMT NUMBER

Previous Post Withdrawal Return Amount, for future use
PREV_WITH_DISB_RETURN_DATE DATE

Previous Post Withdrawal Return Date, for future use
SCHOOL_USE_TXT VARCHAR2 (80)
A field reserved for school information only. Schools may use the field to store information not otherwise tracked, such as campus activity or a school-assigned application ID.
LENDER_USE_TXT VARCHAR2 (80)
A field reserved for lender information only. Lenders may use the field to store information not otherwise tracked, such as branch activity, specific accounting needs, or a lender-assigned application ID. Do not overlay this field with spaces if a previous transmission of Lender Use Only contained a non-blank value
GUARANTOR_USE_TXT VARCHAR2 (80)
A field reserved for guarantor information only. Guarantors may use the field to store information not otherwise tracked, such as loan activity or a guarantor-assigned application ID. Do not overlay this field with spaces if a previous transmission of the Guarantor Use Only field contained a non-blank value.
VALIDATION_EDIT_TXT VARCHAR2 (4000)
Validation Edits for the change record
SEND_RECORD_TXT VARCHAR2 (1000)
Send Record. This is the record that goes into flat 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
REQUEST_ID NUMBER (15)
Standard Who column for Concurrent Program
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column for Concurrent Program
PROGRAM_ID NUMBER (15)
Standard Who column for Concurrent Program
PROGRAM_UPDATE_DATE DATE

Standard Who column for Concurrent Program
Query Text

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


SELECT CLCHGSND_ID
,      AWARD_ID
,      LOAN_NUMBER_TXT
,      CL_VERSION_CODE
,      CHANGE_FIELD_CODE
,      CHANGE_RECORD_TYPE_TXT
,      CHANGE_CODE_TXT
,      STATUS_CODE
,      STATUS_DATE
,      RESPONSE_STATUS_CODE
,      OLD_VALUE_TXT
,      NEW_VALUE_TXT
,      OLD_DATE
,      NEW_DATE
,      OLD_AMT
,      NEW_AMT
,      DISBURSEMENT_NUMBER
,      DISBURSEMENT_DATE
,      CHANGE_ISSUE_CODE
,      DISBURSEMENT_CANCEL_DATE
,      DISBURSEMENT_CANCEL_AMT
,      DISBURSEMENT_REVISED_AMT
,      DISBURSEMENT_REVISED_DATE
,      DISBURSEMENT_REISSUE_CODE
,      DISBURSEMENT_REINST_CODE
,      DISBURSEMENT_RETURN_AMT
,      DISBURSEMENT_RETURN_DATE
,      DISBURSEMENT_RETURN_CODE
,      POST_WITH_DISB_RETURN_AMT
,      POST_WITH_DISB_RETURN_DATE
,      POST_WITH_DISB_RETURN_CODE
,      PREV_WITH_DISB_RETURN_AMT
,      PREV_WITH_DISB_RETURN_DATE
,      SCHOOL_USE_TXT
,      LENDER_USE_TXT
,      GUARANTOR_USE_TXT
,      VALIDATION_EDIT_TXT
,      SEND_RECORD_TXT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGF.IGF_SL_CLCHSN_DTLS;

Dependencies

[top of page]

IGF.IGF_SL_CLCHSN_DTLS does not reference any database object

IGF.IGF_SL_CLCHSN_DTLS is referenced by following:

SchemaAPPS
SynonymIGF_SL_CLCHSN_DTLS