Institution Database, as of May 2006: Institution Transformation Table

RECORDS AND ARCHIVES ADMINISTRATION NATION National Archives and Records Administration 8601 Adelphi Road 1985 College Park, Maryland 20740-6001 OCC Institution Database, 2000-2006 NN3-101-06-002 List of Documentation Number of Pages I. NARA Documentation 1 II. Agency Documentation 22 Total number of pages 23 III. NARA Processing Materials A. AERIC Reports B. File Printouts Prepared by: John LeGloahec Date: July 27, 2006 NARA's web site is http://www.archives.gov NARA Reference Copy OCC.CONT.SERV.06 CONT. SERV. 06 5/162006 OCC Data Fields provided for the National Archives for R-CONS-CON-SERV Standard Element Name Full Element Name Byte Position Data type* Definition Code Values CONS-TYPE-CODE Contracted Service Type 1-2 N A code which Allowable values are : Code identifies the kind of 01 - EDP-Processor; contracted service 02 - EDP-Facilities between the Management; providing institution 03 - EDP-Software; and the receiving 04-Investment Consulting; institution. 05-Bank Compliance;06- Credit Cards Only; 07. Investment Safekeeping Only; 08-Trust Only; 09-Derivatives Only; 10-Mutual Funds Only' CONS-ESTBD-DT Contracted Service 3-10 N The date the Valid date or Zeroes Established Date contracted service type started between the providing institution and receiving institution. CONS-END-DT Contracted Service End Date 11-18 N The date the Allowable values are : contracted service 1 - a valid date; type between the 2 - zeroes if the providing and the contracted service is active receiving institution between the institutions. was terminated. NARA Reference Copy occ. CONT. SERV. 06 5/16/2006 OCC Data Fields provided for the National Archives for R-CONS-CON-SERV Standad Element Name Full Element Name Byte Position Data type* Definition Code Values CONS-ESTBD-REC-DT Contracted Service 19-26 N Date that an OCC Valid Date Established Recorded Date application stored a specific contracted service relationship between one institution and another institution. System generated current date in CCYYMMDD format. CONS-END-REC-DT Contracted Service End 27-34 N Date that an OCC Valid Date or Zeroes Recorded Date application stored the termination of a specific contracted service between one institution and another institution. System generated current date in CCYYMMDD format. NARA Reference Copy occ. CONT. SERV. 06 5/16/2006 OCC Data Fields provided for the National Archives for R-CONS-CON-SERV Standard Element Name Full Element Name Byte Position Data type* Definition Code Values CONSR-INST-OCC-ASGND- Contracted Service Receiver 35-40 N Code assigned by '0-70,000= National Bank ID Institution OCC Assigned ID OCC to identify an 80,000= Federal institution that branches/agencies receives a contracted 90,000= Other banks service from another supervised by OCC institution. 200,000= State member banks(FDIC certificate no. plus 200,000) 300,000= State non member banks (FDIC certificate no. plus 300,000) 400,000= Training banks 500,000= Domestic bank holding companies (FRB holding companies plus 500,000) 600,000= Foreign/domestic companies NARA Reference Copy OCC.CONT.SERV.06 06 5/162006 OCC Data Fields provided for the National Archives for R-CONS-CON-SERV Standad Element Name Full Element Name Byte Position Data type* Definition Code Values CONS-INST-OCC-ASGND- Contracted Service Provider 41-46 N Code assigned by 0-70,000= National Bank ID Institution OCC Assigned Id OCC to identify an 80,000= Federal institution that branches/agencies provides a 90,000= Other banks contracted service to supervised by OCC another institution. 200,000= State member banks(FDIC certificate no. plus 200,000) 300,000= State non member banks (FDIC certificate no. plus 300,000) 400,000= Training banks 500,000= Domestic bank holding companies (FRB holding companies plus 500,000) 600,000= Foreign/domestic companies * Data type N=Numeric X=Alphalnumeric NARA Reference Copy OCC. DOM. BANK.AL BANX.06 5/16/2006 OCC Data Fields provided to the National Archives for R-DOBK-DOM-BANK Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-DOBK-PEER-GRP-NBR Institution Domestic 1-2 N The FFIEC number Allowable values are : 00 thru Bank Peer Group assigned to a 25 inclusive and 99. Number domestic bank which represents a group of domestic banks with similar characteristics based on asset size. INST-DOBK-STAT-CODE Institution Domestic 3-4 N 02 = Pre approved- Bridge Bank Status Code A code indicating the only status of the domestic 03 = Pre approved-Corp reorg bank. 04 = Pre approved- Loan wrkout 11 = Active' 12 = Active- Bridge only 13 = Active - Corp reorg 14 = Active- Loan wrkout 15 = Liquidation 21 = Inactive 22 = Fail - Payoff 23 = Fail Deposit transfer 24 = Fail-P&a' 25 = Dsslv- Mrgr generic 26 = Dsslv- mrgr 27 = Dsslv- P&A 28 = Dssiv-consl 29 = Dsslv- Convrsn 31 = Proposed NARA Reference Copy OCC. DOM. BANK. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-DOBK-DOM-BANK Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-DOBK-TYPE-CODE Institution Domestic 5-6 N A code that identifies 00 - not applicable Bank Type Code the type of domestic 01 - National Bank bank. 02 - State Member Bank 03 - State Non-member Bank 10 Thrift 11 - Savings Bank - Federal 12 Saving Bank State 13 Saving and Load - Federal 14 Savings and Load - state 30 Credit Union 42 State Non-member Trust Company INST-PBUSN-ACT-CODE Institution Primary 7-8 N A code which 00 N/A Business Activity designates the 01 - Commercial/Consumer Code primary business 02 - Consumer non-bank (full activity authorized for service bank) the domestic bank. 03 - Other non-bank 04 - Banker"s bank 05 - Credit card 06 - Trust (non-deposit) 08 - Distributive Bank 09 - Bridge Bank INST-ID Institution Identifier 9-17 N A unique OCC generated identifer for allowable value are 1 throught an institution 999999999 * Type N=Numeric, X=Alpha/Numeric NARA Reference Copy OCC.HIST.LOC.06 a 5/16/2006 OCC Data Fields provided to the National Archives for R-IHLC-HIST-LOCN Standard Element Name Full Element Name Byte Position Data Type * Definition Code Values IHLC-ID Institution History 1-9 N Uniquely identifies an Location Identifier occurrence of historical information about the physical location of the institution. IHLC-EFF-DT Institution History 10-17 N The date that the Valid date or ZEROES Location Effective Date occurrence of the instituion"s location originally became effective. IHLC-ADDR1 Institution History 18-77 X First line of the historical Location Address-1 street address of the institution. IHLC-CITY-NAME Institution History 78-105 X The historical name of Location City Name the city where the institution was previously physically located. IHLC-CNTRY-CODE Institution History 106-110 N Code representing the Reference country code Location Country Code country of a historical table version of location address of an institution. IHLC-CNTY-CODE Institution History 111-113 N Identifies the county Reference FIPS publication Location County Code where the institution was for county identifiers by previously physically state. located. NARA Reference Copy OCC.HIST.LOC.06 LOC. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-IHLC-HIST-LOCN Standard Element Name Full Element Name Byte Position Data Type * Definition Code Values IHLC-ST-ABBRV Institution History 114-115 X The abbreviation of the State code table Location State state where an institution Abbreviation was previously physically located. IHLC-ZIP-CODE Institution History 116-124 N Code that identifies the Refer to postal service Location ZIP Code the Zoned Improvement publication for zip code Program (ZIP). area where the institution was previously physically located. * Data Type N=numeric, A2 X=alpha/numeric NARA Reference Copy OCC. HIST. MAIL * of 5/16/2006 OCC Data Fields provided to the National Archives for R-IHMA-HIST-MAIL Standard Element Name Full Element Name Byte Position Data type* Definition Code Values IHMA-ID Institution History 1-9 N Uniquely identifies a Mailing Address historical occurrence of Identifier the mailing address of the institution. IHMA-EFF-DT Institution History Mail 10-17 N The date that an Valid date or ZEROES Effective Date occurrence of an institution"s mailing address became effective. IHMA-ADDR1 Institution History Mail 18-77 X First line of the historical Address-1 mailing street address of an institution IHMA-CITY-NAME Institution History Mail 78-105 X The historical city name City Name of the mailing address of an institution. IHMA-ST-ABBRV Institution History Mail 106-107 X The abbreviation of the Reference FIPS state State Abbreviation state in which a historical abbreviation publication occurrence of an institution"s mailing address is located. NARA Reference Copy GCC. 1ST. MA MAIL.06 5/16/2006 OCC Data Fields provided to the National Archives for R-IHMA-HIST-MAIL Standard Element Name Full Element Name Byte Position Data type* Definition Code Values IHMA-ZIP-CODE Institution History Mail 108-116 X Code that identifies the Reference the postal ZIP Code the Zoned Improvement service zipcode publication Program (ZIP). area where a historical occurrence of an institution"s mailing address is located. * Data type N=numeric, X=Alpha/numeric NARA Reference Copy OCC.INST.OWN.OI 5/16/2006 OCC Data Fields provided to the National Archives for R-IOWN-INST-OWN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values IOWN-ESTBD-DT Institution Ownership 1-8 N The date the owning Valid date or zeroes. Established Date institution became an owner of the owned institution. IOWN-END-DT Institution Ownership 9-16 N The date that the owning Valid dates or zeroes End Date institution terminated its ownership of the owned institution. IOWN-PCT Institution Ownership 17-19 N If known, the percentage 000 thru 100 Percentage of stock that the owning Value = 000 if percentage institution directly holds unknown in the owned institution. IOWN-ESTBD-REC-DT Institution Ownership 20-27 N Date that an institution"s Valid Date Established Recorded ownership record was Date physically created. System generated current date in CCYYMMDD format. IOWN-END-REC-DT Institution Ownership 28-35 N Date that an OCC Valid Date or zeroes End Recorded Date application stored the termination of an institution"s ownership of a specific institution. System generated current date in CCYYMMDD format. NARA Reference Copy OCC. INST, OWN .06 5/16/2006 OCC Data Fields provided to the National Archives for R-IOWN-INST-OWN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values IOWN-EDP-ESTBD-IND Institution Ownership 36 X Code indicating that this Y = established thru EDP EDP Established ownership relationship servicer screen Indicator was created by an EDP space = not established examiner through the thru EDP servicer screen Supervisory Data N = unestablished thru EDP system. The relationship servicer screen is between an institution that provides EDP service and its one owner institution of interest to the EDP examiner. IOWN-STAT-CODE Institution Ownership 37 X 1 = proposed ownership Status Code A code indicating the 3 = active ownership status of the ownership 4 = inactive ownership of an institution by another institution. IOWN-BY-ID The Institution Number 38-46 N An OCC generated number of the Instition that is that can range from 1 to owned by this institution 999999999 record IOWN-OWN-ID The Institution Number 47-55 N An OCC generated number of the institiution owning that can range from 1 to this institution record 999999999 NARA Reference Copy OCC.TRANS.TYPE.O6 5/16/2006 OCC Dta Fields provided to the National Archives for R-ITRN-INST-TRN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values ITRN-TYPE-CODE Institution Transformation 1-2 N A code designating the Type Code type of transformation in 01 = Merger (Generic); which an institutution is 02 = Merger involved. 03 = Purchase and Assumption 04 = Consolidation 05 = Conversion ITRN-DT Institution Transformation 3-10 N The date that the Date transformation was Valid dates effective ITRN-TO-INST-ID Institution Transformation TO 11-19 N The unique institution this is a number between 1 Institution Identifier identifier of the resulting and 999999999 institution that transformed from one type of institution to another. ITRN-FROM-INST-ID Institution Transformation 20-28 N this is a number between 1 FROM Institution Identifier The unique institution and 999999999 identifier of the original institution that transformed from one type of institution to another. * Data type N=numeric, X=alpha/numeric NARA Reference Copy OCC HIST . NAME.06 06 5/16/2006 OCC Data Fields provided to the National Archives for R-IHFN-HIST-FNAM Standard Element Name Full Element Name Byte Position Data type* Definition Code Values IHFN-ID Institution History Full 1-9 N Uniquely identifies an Any number between 1 and Name Identifier - occurrence of a full name 99999999 charter number change for an institution. IHFN-EFF-DT Institution History Full 10-17 N The effective date of an Valid Date or ZEROES. Name Effective Date institution"s full name prior to its current full name. IHFN-FULL-NAME Institution History Full 18-89 X The historical full name Name of the institution prior to its current full name. * Data type N=numeric, X=Alpha/Numeric NARA Reference Copy OCC.HIST.SNAME.6 OCC. HIST. SNAME. 5/16/2006 OCC Data Fields provided to the National Archives for R-IHSN-HIST-SNAM Standard Element Name Full Element Name Byte Position Data type* Definition Code Values IHSN-ID Institution History Short 1-9 N Uniquely identifies an OCC generated number Name Identifier occurrence of short between 1 and 99999999 name history for an institution. IHSN-EFF-DT Institution History Short 10-17 N The effective date of an Valid Date or ZEROES Name Effective Date institution"s short name prior to its current short name. IHSN-SHORT-NAME Institution History Short 18-57 X The historical short Name name of the institution prior to its current short name. * Data type N=numeric, X=alpha/numeric NARA Reference Copy occ. INST. INSTU-06 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-ID Institution Identifier 1-9 N A unique OCC generated Allowable values are 1 thru identifier for an 999999999 institution. INST-TYPE-CODE Institution Type Code 10-11 N A numeric code that 01 - Domestic Bank; designates the institution 02 - Domestic Bank type. Subsidiary 03 - Branch; 04 - Domestic Bank Holding Company' 05 Foreign Branch/Agency; 06 - Foreign Bank' 07 - Foreign/Domestic Company; 08 Domestic Bank/Holding' 09 - Edge/Agreement Corp. Company Subsidiary' 10 - Joint Venture/Limited Liability Corp. 11 - Bank Service Corporation 12 - Limited Liability Corporation (LLC) NARA Reference Copy 1 OCC. 1 NST. / NSTU. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-OCC-ASGND-ID Institution OCC 12-17 N A number assigned by '0-70,000= National Bank Assigned Identifier OCC that identifies an 80,000= Federal institution. This includes branches/agencies OCC Charter Number 90,000= Other banks and OCC Pseudo supervised by OCC Charter Number 200,000= State member See Comments for banks(FDIC certificate no. NBSVDS short Name * plus 200,000) Other systems accessing 300,000= State non this element - IE; CM; IB, member banks (FDIC ES, LE certificate no. plus 300,000) 400,000= Training banks 500,000= Domestic bank holding companies (FRB holding companies plus 500,000) 600,000= Foreign/domestic companies INST-FDIC-CERT-ID Institution FDIC 18-23 N A number assigned by O thru 999999 Range Certificate Identifier the FDIC to identify Values. May be duplicated insured and some on occasions uninsured banking institutions. NARA Reference Copy 2 occ. OCC.INST.INSTU.0 INST. INSTU. 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-FRB-DHC-ID Institution FRB 24-29 N A number assigned by values range from 0 thru Domestic Holding the Federal Reserve 999999. Company Identifier Board to identify a Domestic Bank Holding Company. INST-FRB-BANK-ID Institution FRB Bank 30-35 N A number assigned by Allowable values format is Identifier the Federal Reserve State Code Abbreviation (2 Board to identify banks char.) + 4 digit assigned that are members of the by the FRB. If unknown, Federal Banking System. populate with all spaces. Current default in LIS is state numeric code + 0000. INST-FULL-NAME Institution Full Name 36-107 X The current full name of the institution. INST-FULNAME-EFF-DT Institution Full Name 108-115 N The date that the full Valid date or Zeroes Effective Date name of the institution went into effect NARA Reference Copy 3 OCC. INST. INSTU. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-SHORT-NAME Institution Short Name 116-155 X The abbreviated name of the institution; for OCC chartered institutions the short name will include the city of location; for other institutions it may be the first 40 characters of the full name. For NBSVDS short names See comments Retrieval Apps Con INST-LOC-ADDR1 Institution Location 156-215 X Street address where the Address Line 1 institution is physically located. INST-LOC-ADDR2 Institution Location 216-275 X Street address where the Address Line 2 institution is physically located. Additional line if needed. INST-LOC-CITY-NAME Institution Location 276-303 X City where the institution City Name is physically located. NARA Reference Copy 4 OCC. INST. INSTU. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-LOC-ST-ABBRV Institution Location 304-305 X State where the See FIPS 2 character state State Abbreviation institution is physically abbreviations publication located. Two-digit alpha for values abbreviation representing the postal abbreviation of the state where the institution is located. INST-LOC-ZIP-CODE Institution Location 306-314 N Postal Zip Code where Refer to the Postal Service Zip Code the institution is publication of Zip Codes for physically located. allowable values OR zeroes. INST-LOC-CNTY-CODE Institution Location 315-317 N The county where the Refer to FIPS publication County Code institution is physically for county identifiers by located. state for allowable values OR zeroes. INST-LOC-CNTRY-CODE Institution Location 318-322 N The numeric code of the Reference the FIPS 5 digit Country Code country where the country code publication for institution is physically allowable values OR located. zeroes. NARA Reference Copy 5 OEC. INST. INSTU. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-MAIL-ADDR1 Institution Mailing 323-382 X Address line of an Address Line 1 institution for mailing purposes. INST-MAIL-ADDR2 Institution Mailing 382-442 X Mailing address of the Address Line 2 institution for mailing purposes. Additional line if needed. INST-MAIL-CITY-NAME Institution Mailing City 443-470 X The city name of the Name institution for mailing purposes. INST-MAIL-ST-ABBRV Institution Mailing 471-472 X The abbreviation of the Reference the FIPS 2 State Abbreviation state of the institution for character state abbreviation mailing purposes. publication for allowable values or SPACES. INST-MAIL-ZIP-CODE Institution Mailing Zip 473-481 N Postal Zip code of the Reference the Postal Code institution for mailing Services Zip Code purposes. publication for allowable values or ZEROES. NARA Reference Copy 6 OCC. INST. ) NSTU. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-MAIL-CNTRY-CODE Institution Mailing 482-486 N The code designating the Reference the FIPS 5 digit Country Code country of the institution country code publication for for mailing purposes. allowable values OR zeroes. INST-FRB-DIST-CODE Institution FRB District 487-488 N A number that identifies Allowable values are 00 Code the Federal Reserve thru 12 or 99 District Bank serving the area where the institution is located. See Comments for NBSVDS Short name INST-OCC-DIST-CODE Institution OCC 489-490 N A code representing the 0 = not applicable District Code OCC district in which an 1 = Northeast institution is 2 = Southeast geographically located. 3 = Central 4 = Midwest 5 = Southwest 6 = West 7 = Multinational NARA Reference Copy 7 OCC.INST., INSTU.06 NST. 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-MSA-NBR Institution MSA 491-494 N A number that identifies Reference FIPS PUB 8-5, Number a geographic area Metropolitan Statistical consisting of a large Areas OR zeroes. population (50,000 to 1 million) nucleus having a high degree of economic and social integration. INST-PRIM-REG-CODE Institution Primary 495-496 N A numeric code 00 - N/A or Unknown Regulator Code designating the primary 01 OCC agency responsible for 02 FDIC regulating the 03 - FRB supervisory activities for 04 - OTS the institution. 05 NCUA 06 State Agency Branches contain the same value as owning Institutions INST-ESTBD-DT Institution Established 497-504 N The date that the Valid date or Zeroes Date institution was legally A further delimiter is that if organized. If OCC the date is valid, it must chartered, the OCC be in the range 17000101 charter date. current date. INST-OPEN-DT Institution Open Date 505-512 N The date the institution Valid Date or zeroes. opened for business. NARA Reference Copy 8 OCC. INST. INSTU.O. 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-ACTVE-CODE Institution Active Code 513 N The code designating Allowable values are : whether the institution is 0 = Unknown; active, not active, 1 = Active; proposed, or unknown 2 = Inactive 3 = Proposed INST-INACTVE-DT Institution Inactive 514-521 N The date that the Valid date in CCYYMMDD Date institution became format or zeroes inactive. INST-TR-ACTV-IND Institution Trust 522 N The indicator designating Allowable values are : Activitiy Indicator whether trust activity is 1 - - Exercised exercised at this 2- - Not Exercised (default) institution. 0 - Not Applicable INST-TR-POWERS-CODE Institution Trust 523 N A code identifies the type 0 - - No Trust Powers Powers Code of trust powers granted (default) ; to the institution. 1- - Full Trust Powers Granted ; 2- - Limited Trust Powers Granted NARA Reference Copy 9 DCC.INST.INSTU.06 INST, 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-TFAG-SEC-ID Institution Transfer 524-531 N The SEC assigned Numeric including zeroes. Agent Security number for institutions Identifier that are registered transfer agents. INST-TFAG-EFF-DT Institution Transfer 532-539 N The effective date an Valid date or zeroes Agent Effective Date institution became a registered transfer agent. INST-TFAG-DEL-DT Institution Transfer 540-547 N The date the institutions Valid date or zeroes Agent Delete Date transfer agent status is cancelled. INST-EDP-PRVR-TO-CODE Institution EDP 548 N A code indicates the 0 - - Does not provide Provider To Code extent to which an services institution provides data 1 - - Services self only processing services. 2- - Services other institutions only 3 - - Provides to self and other institutions NARA Reference Copy 10 OCC.INST.INSTO.OC INST. NSTU. or 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-EDP-PRVR-STAT- Institution EDP 549 N The code indicates the 0 = Does not provide CODE Provider Status Code institution"s status in services providing data 1 = Is actively providing processing services. services 2 = Is currently inactive as a servicer INST-EDP-PRVR-INACTVE- Institution EDP 550-557 N The date that the EDP Allowable values are zeroes DT Provider Inactive Date provider status became or a valid date. inactive for the institution. INST-BSUB-TYPE-CODE Institution Bank 558-559 X A code which identifies Allowable values are : Subsidiary Type Code the type of bank 00 - - Not Applicable; subsidiary. 01 - Operating (Other than Mortgage); 02 - Statutory (Bank Service Corp.); 03 - Statutory (Other); 05 - Operating (Mortgage); removed NARA Reference Copy 11 Occ. INST. NSTV. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-BRAN-SPCL-TYPE- Institution Branch 560-561 X A code which designates Allowable values are : CODE Specialty Type Code that a branch is brick-and- 00 = N/A; mortar (with or without 01 = brick and mortar CBCTs) or a CBCT only. 02 = CBCT only This element is not applicable for other types of institutions. INST-BRAN-PRE-APRL-IND Institution Branch 562 X An indicator of whether Preliminary Approval the branch has been Indicator preliminarily approved or is in some other status. INST-BRAG-TYPE-CODE Institution 563 X A code that identifies the 1 = Federal (default for Branch/Agency Type branch/agency type. federal branch/agency) Code 2 = State space = not applicable (default when not a federal branch/agcy) INST-BRAG-STAT-CODE Institution 564 X A code representing the 1 = federal branch Branch/Agency Status status of an institution 2 = federal agency Code that is a federal branch 3 = limited federal branch or agency, i. e. SPACE = Unknown for , Federal Branch, Federal Federal Branch/Agency Agency, or Limited institution types Federal Branch. NARA Reference Copy 12 occ. INST. INSTU. 06 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-ESTBD-REC-DT Institution Established 565-572 N The date that Institution Valid Date or Zeroes. Recorded Date Established Date (INST- Default value is Zeroes. ESTBD-DT). was recorded in the Institution Database. INST-INACTVE-REC-DT Institution Inactive 573-580 N The date that Institution Valid Date or Zeroes. Recorded Date Inactive Date (INST- Default value is Zeroes. INACTVE-DT). was recorded in the Institution Database. INST-LOC-EFF-DT Institution Location 581-588 N Tha date the institution"s Valid date or zeroes. Address Effective location address became Date effective. INST-MAIL-EFF-DT Institution Mailing 589-596 N Date that an institution"s Valid date or zeroes. Address Effective mailing address became Date effective. INST-SHORT-NAME-EFF-DT Institution Short Name 597-604 N Date that an institution"s Valid date or zeroes. Effective Date short name became effective. NARA Reference Copy 13 OCC. INST. NSTU. of 5/16/2006 OCC Data Fields provided to the National Archives for R-INST-INSTITUTN Standard Element Name Full Element Name Byte Position Data type* Definition Code Values INST-OCC-BRANCH-CERT- Institution OCC 605-611 X A number assigned by Valid values are SPACES ID Branch Certificate OCC for the purpose of or Identifier identifying Branches of First 6 numeric characters: National Banks that 0 thru 999999 perform banking Last character codes: activities. A = Brick and mortar facility C = CBCT Facility INST-FRB-RSSD-NR Institution Federal 612-621 N The sequential (one-up) numeric Reserve Board RSSD number generated by the Number Federal Reserve Board to uniquely identify an institution in the FRB National Information Center (NIC) database. Note: The FRB RSSD NR never changes throughout the life of the institution. INST-FDIC-INS-CD Institution FDIC 622 X The code indicating the 0=N/A, Insurance Code FDIC deposit-related 1=NO DEPOSITS, insurance status of the 2=FDIC INSURED, institution. 3=FDIC DE-INS INST-SAVE-OCC-DIST- OCC District Code 623 X Historical District code Alphanumeric CODE NARA Reference Copy 14