1.17 Entity Bulk Import Pension Upload
This topic provides detailed information on entity bulk import pension upload.
The entity import for Pension for bank and branch with the interface ID IF20150020001001(Entity bulk import in Pension).
Table 1-93 Entity Bulk Import Pension Upload
| Field Name | Description | Data type | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segment ID | VARCHAR2 | 16 | PATB_ENTITYBASEUPLOAD |
| SEQUENCENUMBER | Sequence number | NUMBER | 10 | PATB_ENTITYBASEUPLOAD |
| PROCESSID | Process ID | VARCHAR2 | 50 | PATB_ENTITYBASEUPLOAD |
| BULKCLIENTCODE | Bulk client code | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| IMPORTFILENAME | Import file name | VARCHAR2 | 255 | PATB_ENTITYBASEUPLOAD |
| UPLOADMODE | Upload mode | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| ENTITYID | Entity ID | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| ENTITYNAME | Entity name | VARCHAR2 | 60 | PATB_ENTITYBASEUPLOAD |
| ENTITYTYPE | Entity type | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| ENTITYBASECURRENCY | Entity base currency | VARCHAR2 | 3 | PATB_ENTITYBASEUPLOAD |
| SWITCHINGLOGIC | Switching logic | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| UHGENERATIONLOGIC | Uh generation logic | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| NATUREOFBUSINESS | Nature of business | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| SECTION | Section | VARCHAR2 | 40 | PATB_ENTITYBASEUPLOAD |
| EFFECTIVEDATEFORCAPITALGAINS | Effective date for capital gains | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| ENTITYSUBTYPE | Entity subtype | VARCHAR2 | 3 | PATB_ENTITYBASEUPLOAD |
| CROSSBRANCHING | Cross branching | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| FUNDSPOWERINSTALLED | Funds power installed | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| PARENTENTITY | Parent entity | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| CUSTOMERINTERFACEKEY | Customer interface key | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| ONLINEINTERFACE | Online interface | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| MAKER_ID | Maker_ID | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| MAKER_ DT_STAMP | Maker_ Dt_Stamp | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| CHECKER_ID | Checker_ID | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| CHECKER_ DT_STAMP | Checker_ Dt_Stamp | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| LASTMODIFIEDUSERID | Last modified user ID | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| LASTMODIFIEDDATE | Last modified date | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_ENTITYBASEUPLOAD |
| LASTSERIALNUMBER | Last serial number | NUMBER | 22 | PATB_ENTITYBASEUPLOAD |
| SIGNOFF | Sign off | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| WEEKENDBITS | Weekend bits | VARCHAR2 | 7 | PATB_ENTITYBASEUPLOAD |
| AUTHORIZEDSIGNATORY | Authorized signatory | VARCHAR2 | 70 | PATB_ENTITYBASEUPLOAD |
| RULEEFFECTIVEDATE | Rule effective date | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| ENTITYCATEGORYTYPE | Entity category type | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| ENTITYCATEGORY | Entity category | VARCHAR2 | 2 | PATB_ENTITYBASEUPLOAD |
| LINKENTITYID | Link entity ID | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| LINKENTITYTYPE | Link entity type | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| SEQUENCETYPE | Sequence type | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| CHANNELENTITY | Channel entity | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| MICRCODE | Micrcode | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| RECORD_STAT | Record_Stat | CHAR | 1 | PATB_ENTITYBASEUPLOAD |
| ONCE_AUTH | Once_Auth | CHAR | 1 | PATB_ENTITYBASEUPLOAD |
| FINWAREPOSTING | Finwareposting | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| USINDICIAAVAILABLE | Us indicia available | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| FATCASTATUS | Fatca status | VARCHAR2 | 25 | PATB_ENTITYBASEUPLOAD |
| NATIONALITY | Nationality | VARCHAR2 | 3 | PATB_ENTITYBASEUPLOAD |
| COUNTRYOFBIRTH | Country of birth | VARCHAR2 | 3 | PATB_ENTITYBASEUPLOAD |
| COUNTRYOFDOMICILE | Country of domicile | VARCHAR2 | 3 | PATB_ENTITYBASEUPLOAD |
| INCORPORATIONCOUNTRY | Incorporation country | VARCHAR2 | 3 | PATB_ENTITYBASEUPLOAD |
| TAXID | Tax ID | VARCHAR2 | 50 | PATB_ENTITYBASEUPLOAD |
| EIN | Ein | VARCHAR2 | 50 | PATB_ENTITYBASEUPLOAD |
| TAXCERTIFICATEEFFEDATE | Tax certificate effe date | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| TAXCERTIFICATEEXPDATE | Tax certificate exp date | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| TAXCIRCLE | Tax circle | VARCHAR2 | 15 | PATB_ENTITYBASEUPLOAD |
| TAXCATEGORY | Tax category | VARCHAR2 | 10 | PATB_ENTITYBASEUPLOAD |
| FATCACLASSIFICATION | Fatca classification | VARCHAR2 | 25 | PATB_ENTITYBASEUPLOAD |
| GIIN | Giin | VARCHAR2 | 30 | PATB_ENTITYBASEUPLOAD |
| GIINISSUEDATE | Giin issue date | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| GIINEXPIRYDATE | Giin expiry date | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| GIINVERIFIEDFLAG | Giin verified flag | NUMBER | 1 | PATB_ENTITYBASEUPLOAD |
| FATCASPONSORTYPE | Fatca sponsor type | VARCHAR2 | 2 | PATB_ENTITYBASEUPLOAD |
| SPONSORINGENTITYTYPE | Sponsoring entity type | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| SPONSORINGENTITYID | Sponsoring entity ID | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| MINISATRANSFERIN | Minisatransferin | NUMBER | 30 | PATB_ENTITYBASEUPLOAD |
| MINISATRANSFEROUT | Minisatransferout | NUMBER | 30 | PATB_ENTITYBASEUPLOAD |
| ISAREFERENCENO | Isareferenceno | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| FUNDSTRUCTAPPLICABLE | Fundstructapplicable | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| AUTOSETTLESWITCH | Autosettleswitch | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| CREATEDMODULE | Createdmodule | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| SWIFTMSGLIST | Swiftmsglist | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| ELECTRONICDEALFLAG | Electronicdealflag | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| LEGACYUHREF | Legacyuhref | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| PAYDIVIDENDDURINGRED | Paydividendduringred | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| DEFAULTAGENCYBRANCH | Defaultagencybranch | VARCHAR2 | PATB_ENTITYBASEUPLOAD | |
| DATEOFBIRTH | Dateofbirth | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| ENTCLOSEDDATE | Entcloseddate | DATE | 7 | PATB_ENTITYBASEUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ENTITYBASEUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ENTITYBASEUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_ENTITYBASEUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| ENTITYID | Entityid | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| ENTITYTYPE | Entitytype | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PATB_ENTITYBASEUPLOAD |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PATB_ENTITYBASEUPLOAD |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 16 | PATB_ENTITYBASEUPLOAD |
| ACCOUNTNAME | Accountname | VARCHAR2 | 100 | PATB_ENTITYBASEUPLOAD |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PATB_ENTITYBASEUPLOAD |
| BENEFICIARYID | VARCHAR2(12) | No | Beneficiary ID | |
| BENEFICIARYPERCENTAGE | NUMBER(5,2) | No | Beneficiary Percentage |
Note:
This is applicable only for PENSION module.Parent topic: Appendix A - Upload File Formats A