| Series | Schedule | Database Table | XML Table | Worksheet | StartDate | EndDate | Technical Field Name / MDRM | Report Form Line Item | Attributes / Format (Date / Text / Numeric) |
FieldType (DateTime / Varchar / Numeric) |
Primary Key | Item Descriptions | Derived Item (Yes/No) |
Item Derivation Calculation | Comments | Status |
| DFAST14A | SCNR | SCNR_DEF | SCNR_Data_Collect_DEF | Variable Definitions | 20171231 | 99991231 | ID_RSSD | RSSD ID | Numeric | Numeric (7,0) | Yes | Unique ID of the Reporting Institution | No | No Change | ||
| DFAST14A | SCNR | SCNR_DEF | SCNR_Data_Collect_DEF | Variable Definitions | 20171231 | 99991231 | CCSV9017 | Institution Name | Text | Varchar (100) | No | Institution Name | Yes | Derived from ID_RSSD | No Change | |
| DFAST14A | SCNR | SCNR_DEF | SCNR_Data_Collect_DEF | Variable Definitions | 20171231 | 99991231 | D_DT | D_DT | DateTime | DateTime | Yes | Reporting Quarter End Date (YYYY-MM-DDT00:00:00) | No | No Change | ||
| DFAST14A | SCNR | SCNR_DEF | SCNR_Data_Collect_DEF | Variable Definitions | 20171231 | 99991231 | Transtype | Transtype | Text | Varchar (1) | Yes | TransType (Insert "I") | No | No Change | ||
| DFAST14A | SCNR | SCNR_DEF | SCNR_Data_Collect_DEF | Variable Definitions | 20171231 | 99991231 | CCSVR929 | Variable Number | Numeric | Numeric (10,0) | Yes | Variable Number | No | No Change | ||
| DFAST14A | SCNR | SCNR_DEF | SCNR_Data_Collect_DEF | Variable Definitions | 20171231 | 99991231 | CCSVS019 | Variable Name | Text | Varchar (500) | No | Variable Name | No | It is preferred to differentiate regional variables in a consistent manner using both geographic names and standardized geographic codes. For example, geographic codes (ex. FIPS, CBSA, etc.) can be added as the suffix of a Variable Name separated by a delimiter (e.g. “HPI; Metropolitan Statistical Area; Washington-Arlington-Alexandria, DC-VA-MD-WV; 47900”). | No Change | |
| DFAST14A | SCNR | SCNR_DEF | SCNR_Data_Collect_DEF | Variable Definitions | 20171231 | 99991231 | CCSVS064 | Variable Definition | Text | Varchar (5000) | No | Variable Definition | No | No Change | ||
| DFAST14A | SCNR | SCNR_VAL | SCNR_Data_Collect_VAL | Scenarios | 20171231 | 99991231 | ID_RSSD | RSSD ID | Numeric | Numeric (7,0) | Yes | Unique ID of the Reporting Institution | No | No Change | ||
| DFAST14A | SCNR | SCNR_VAL | SCNR_Data_Collect_VAL | Scenarios | 20171231 | 99991231 | CCSV9017 | Institution Name | Text | Varchar (100) | No | Institution Name | Yes | Derived from ID_RSSD | No Change | |
| DFAST14A | SCNR | SCNR_VAL | SCNR_Data_Collect_VAL | Scenarios | 20171231 | 99991231 | D_DT | D_DT | DateTime | DateTime | Yes | Reporting Quarter End Date (YYYY-MM-DDT00:00:00) | No | No Change | ||
| DFAST14A | SCNR | SCNR_VAL | SCNR_Data_Collect_VAL | Scenarios | 20171231 | 99991231 | Transtype | Transtype | Text | Varchar (1) | Yes | TransType (Insert "I") | No | No Change | ||
| DFAST14A | SCNR | SCNR_VAL | SCNR_Data_Collect_VAL | Scenarios | 20171231 | 99991231 | CCSVP006 | Scenario | Text | Varchar (50) | Yes | Scenario | No | No Change | ||
| DFAST14A | SCNR | SCNR_VAL | SCNR_Data_Collect_VAL | Scenarios | 20171231 | 99991231 | CCSVR929 | Variable Number | Text | Numeric (10,0) | Yes | Variable Number | No | No Change | ||
| DFAST14A | SCNR | SCNR_VAL | SCNR_Data_Collect_VAL | Scenarios | 20171231 | 99991231 | CCSVP009 | Projection Period | Text | Varchar (50) | Yes | Projection Period | No | No Change | ||
| DFAST14A | SCNR | SCNR_VAL | SCNR_Data_Collect_VAL | Scenarios | 20171231 | 99991231 | CCSVS291 | Variable Value | Numeric | Numeric (28,6) | No | Variable Value | No | No Change |
| File Type | application/vnd.ms-excel |
| File Modified | 2021-02-22 |
| File Created | 2019-01-29 |