1.44.2 Pension Investment Account Upload
This topic provides detailed information on the Pension Investment Account Upload.
Table 1-165 Pension Investment Account Upload
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHPARTYMASTERUPLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHPARTYMASTERUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHPARTYMASTERUPLOADTBL |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PHPARTYMASTERUPLOADTBL |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PHPARTYMASTERUPLOADTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHPARTYMASTERUPLOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHPARTYMASTERUPLOADTBL |
| PARTYTYPE | Partytype | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| TITLE | Title | VARCHAR2 | 15 | PHPARTYMASTERUPLOADTBL |
| FIRSTNAME | Firstname | VARCHAR2 | 100 | PHPARTYMASTERUPLOADTBL |
| MIDDLENAME | Middlename | VARCHAR2 | 100 | PHPARTYMASTERUPLOADTBL |
| LASTNAME | Lastname | VARCHAR2 | 100 | PHPARTYMASTERUPLOADTBL |
| REGISTEREDNAME | Registeredname | VARCHAR2 | 100 | PHPARTYMASTERUPLOADTBL |
| DATEOFBIRTH | Dateofbirth | DATE | 7 | PHPARTYMASTERUPLOADTBL |
| DATEOFINCORPORATION | Dateofincorporation | DATE | 7 | PHPARTYMASTERUPLOADTBL |
| MARITALSTATUS | Maritalstatus | VARCHAR2 | 1 | PHPARTYMASTERUPLOADTBL |
| OCCUPATION | Occupation | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| GENDER | Gender | VARCHAR2 | 1 | PHPARTYMASTERUPLOADTBL |
| PREFERREDCURRENCY | Preferredcurrency | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| MINOR | Minor | NUMBER | 1 | PHPARTYMASTERUPLOADTBL |
| NATIONALITY | Nationality | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| COUNTRYOFDOMICILE | Countryofdomicile | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| COUNTRYOFBIRTH | Countryofbirth | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| DUALNATIONALITY | Dualnationality | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| SUBSTANTIALSTAYINUS | Substantialstayinus | NUMBER | 1 | PHPARTYMASTERUPLOADTBL |
| HEALTHSTATUS | Healthstatus | VARCHAR2 | 1 | PHPARTYMASTERUPLOADTBL |
| PROTECTIONLEVEL | Protectionlevel | VARCHAR2 | 1 | PHPARTYMASTERUPLOADTBL |
| FIRSTAUTHORIZEDSIGNATORY | Firstauthorizedsignatory | VARCHAR2 | 100 | PHPARTYMASTERUPLOADTBL |
| SECONDAUTHORIZEDSIGNATORY | Secondauthorizedsignatory | VARCHAR2 | 100 | PHPARTYMASTERUPLOADTBL |
| THIRDAUTHORIZEDSIGNATORY | Thirdauthorizedsignatory | VARCHAR2 | 100 | PHPARTYMASTERUPLOADTBL |
| CORPORATIONTYPE | Corporationtype | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| MINNOOFCORPORATESIGNATOR Y | Minnoofcorporatesignatory | NUMBER | 22 | PHPARTYMASTERUPLOADTBL |
| INCORPORATIONCOUNTRY | Incorporationcountry | VARCHAR2 | 3 | PHPARTYMASTERUPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHPARTYMASTERUPLOADTBL |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PHPARTYMASTERUPLOADTBL |
| MAKER_DT_STAM P | Maker_Dt_Stamp | DATE | 7 | PHPARTYMASTERUPLOADTBL |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PHPARTYMASTERUPLOADTBL |
| CHECKER_DT_STAM P | Checker_Dt_Stamp | DATE | 7 | PHPARTYMASTERUPLOADTBL |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PHPARTYMASTERUPLOADTBL |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PHPARTYMASTERUPLOADTBL |
| RECORD_STA T | Record_Stat | VARCHAR2 | 1 | PHPARTYMASTERUPLOADTBL |
| MOD_NO | Mod_No | NUMBER | 22 | PHPARTYMASTERUPLOADTBL |
| FATHERSPOUSENAM E | Fatherspousename | VARCHAR2 | 105 | PHPARTYMASTERUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHPARTYCONTACTUPLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHPARTYCONTACTUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHPARTYCONTACTUPLOADTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHPARTYCONTACTUPLOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHPARTYCONTACTUPLOADTBL |
| CONTACTREFNO | Contactrefno | VARCHAR2 | 16 | PHPARTYCONTACTUPLOADTBL |
| ADDRESSTY PE | Addresstype | VARCHAR2 | 2 | PHPARTYCONTACTUPLOADTBL |
| ADDRESSLINE1 | Addressline1 | VARCHAR2 | 100 | PHPARTYCONTACTUPLOADTBL |
| ADDRESSLINE2 | Addressline2 | VARCHAR2 | 100 | PHPARTYCONTACTUPLOADTBL |
| ADDRESSLINE3 | Addressline3 | VARCHAR2 | 100 | PHPARTYCONTACTUPLOADTBL |
| POSTBOXNO | Postboxno | VARCHAR2 | 16 | PHPARTYCONTACTUPLOADTBL |
| CITY | City | VARCHAR2 | 80 | PHPARTYCONTACTUPLOADTBL |
| STATE | State | VARCHAR2 | 80 | PHPARTYCONTACTUPLOADTBL |
| COUNTRY | Country | VARCHAR2 | 3 | PHPARTYCONTACTUPLOADTBL |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PHPARTYCONTACTUPLOADTBL |
| BICCODE | Biccode | VARCHAR2 | 16 | PHPARTYCONTACTUPLOADTBL |
| WEBSITE | Website | VARCHAR2 | 100 | PHPARTYCONTACTUPLOADTBL |
| EMAILADDRESS | Emailaddress | VARCHAR2 | 100 | PHPARTYCONTACTUPLOADTBL |
| EFFECTIVEFROMDATE | Effectivefromdate | DATE | 7 | PHPARTYCONTACTUPLOADTBL |
| EFFECTIVETODATE | Effectivetodate | DATE | 7 | PHPARTYCONTACTUPLOADTBL |
| PRIMARY CONTACT PERSON | Primarycontactperson | VARCHAR2 | 100 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYINTERNDIALCODE1 | Primaryinterndialcode1 | VARCHAR2 | 10 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYINTERNDIALCODE2 | Primaryinterndialcode2 | VARCHAR2 | 10 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYINTERNDIALCODE3 | Primaryinterndialcode3 | VARCHAR2 | 10 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYINTERNDIALCODE4 | Primaryinterndialcode4 | VARCHAR2 | 10 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYPOSITION | Primaryposition | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYMOBILENUMBER1 | Primarymobilenumber1 | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYMO BILENUM BER2 | Primarymobilenumber2 | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYFIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| FAX | Fax | VARCHAR2 | 120 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYCONTACTINSTRN | Primarycontactinstrn | VARCHAR2 | 100 | PHPARTYCONTACTUPLOADTBL |
| PRIMARYEXTN | Primaryextn | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| SECONDARYCONTACTPERSON | Secondarycontactperson | VARCHAR2 | 100 | PHPARTYCONTACTUPLOADTBL |
| SECONDARYINTERNDIALCODE1 | Secondaryinterndialcode1 | VARCHAR2 | 10 | PHPARTYCONTACTUPLOADTBL |
| SECONDARYINTERNDIALCODE2 | Secondaryinterndialcode2 | VARCHAR2 | 10 | PHPARTYCONTACTUPLOADTBL |
| SECONDARYPOSITION | Secondaryposition | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| SECONDARYMOBILENUMBER | Secondarymobilenumber | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| SECONDARYFIXEDLINE | Secondaryfixedline | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| SECONDARYCONTACTINSTRN | Secondarycontactinstrn | VARCHAR2 | 105 | PHPARTYCONTACTUPLOADTBL |
| SECOND ARYEXTN | Secondaryextn | VARCHAR2 | 60 | PHPARTYCONTACTUPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHPARTYCONTACTUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHPARTYIDUPLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHPARTYIDUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHPARTYIDUPLOADTBL |
| USERREFER ENCENUM BER | Userreferencenumber | VARCHAR2 | 16 | PHPARTYIDUPLOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHPARTYIDUPLOADTBL |
| IDREFERENCENO | Idreferenceno | VARCHAR2 | 16 | PHPARTYIDUPLOADTBL |
| IDENTIFICATIONTYPE | Identificationtype | VARCHAR2 | 20 | PHPARTYIDUPLOADTBL |
| IDENTIFICATIONNUMBER | Identificationnumber | VARCHAR2 | 50 | PHPARTYIDUPLOADTBL |
| PLACEOFISSUE | Placeofissue | VARCHAR2 | 3 | PHPARTYIDUPLOADTBL |
| ISSUEAUTHORITY | Issueauthority | VARCHAR2 | 50 | PHPARTYIDUPLOADTBL |
| ISSUECOUNTRY | Issuecountry | VARCHAR2 | 3 | PHPARTYIDUPLOADTBL |
| DATEOFISSUE | Dateofissue | DATE | 7 | PHPARTYIDUPLOADTBL |
| DATEOFEXPIRY | Dateofexpiry | DATE | 7 | PHPARTYIDUPLOADTBL |
| LASTVERIFIEDDATE | Lastverifieddate | DATE | 7 | PHPARTYIDUPLOADTBL |
| VERIFICATIONSTATUS | Verificationsta tus | VARCHAR2 | 1 | PHPARTYIDUPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHPARTYIDUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHINVACCMASTERUPLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHINVACCMASTERUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHINVACCMASTERUPLOADTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHINVACCMASTERUPLOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHINVACCMASTERUPLOADTBL |
| ACOPERATIONTYPE | Acoperation type | VARCHAR2 | 1 | PHINVACCMASTERUPLOADTBL |
| DEALINGTYPE | Dealingtype | VARCHAR2 | 3 | PHINVACCMASTERUPLOADTBL |
| GUARDIANID | Guardianid | VARCHAR2 | 12 | PHINVACCMASTERUPLOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHINVACCMASTERUPLOADTBL |
| INVESTORCATEGORY | Investorcate gory | VARCHAR2 | 2 | PHINVACCMASTERUPLOADTBL |
| ACOPENINGDATE | Acopeningdate | DATE | 7 | PHINVACCMASTERUPLOADTBL |
| ACCOUNTREFNO | Accountrefno | VARCHAR2 | 16 | PHINVACCMASTERUPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHINVACCMASTERUPLOADTBL |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PHINVACCMASTERUPLOADTBL |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PHINVACCMASTERUPLOADTBL |
| RECORD_STA T | Record_Stat | VARCHAR2 | 1 | PHINVACCMASTERUPLOADTBL |
| MOD_NO | Mod_No | NUMBER | 22 | PHINVACCMASTERUPLOADTBL |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PHINVACCMASTERUPLOADTBL |
| MAKER_DT_STAM P | Maker_Dt_Stamp | DATE | 7 | PHINVACCMASTERUPLOADTBL |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PHINVACCMASTERUPLOADTBL |
| CHECKER_DT_STAM P | Checker_Dt_Stamp | DATE | 7 | PHINVACCMASTERUPLOADTBL |
| ACCOUNTSTATUS | Accountstatus | VARCHAR2 | 1 | PHINVACCMASTERUPLOADTBL |
| PENSIONACCOUNT | Pensionaccount | VARCHAR2 | 1 | PHINVACCMASTERUPLOADTBL |
| ACCOUNTCLOSED | Accountclosed | VARCHAR2 | 1 | PHINVACCMASTERUPLOADTBL |
| CHANGEDATE | Changedate | DATE | 7 | PHINVACCMASTERUPLOADTBL |
| CHANGEREASON | Changereason | VARCHAR2 | 255 | PHINVACCMASTERUPLOADTBL |
| CHANGEREFERENCENO | Changereferenceno | VARCHAR2 | 16 | PHINVACCMASTERUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHINVACCINTERU PLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHINVACCINTERU PLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHINVACCINTERU PLOADTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHINVACCINTERU PLOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHINVACCINTERU PLOADTBL |
| INTERMEdiaRYID | Intermediaryid | VARCHAR2 | 12 | PHINVACCINTERU PLOADTBL |
| SPLITPERCENTAGE | Splitpercentage | NUMBER | 5 | PHINVACCINTERU PLOADTBL |
| DEFAULTFLAG | Defaultflag | VARCHAR2 | 1 | PHINVACCINTERU PLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHINVACCBANKUPLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHINVACCBANKUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHINVACCBANKUPLOADTBL |
| USERREFER ENCENUM BER | Userreference number | VARCHAR2 | 16 | PHINVACCBANKUPLOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHINVACCBANKUPLOADTBL |
| BANKREFERENCENO | Bankreferen ceno | VARCHAR2 | 16 | PHINVACCBANKUPLOADTBL |
| DIRECTDEBITAPPLICABLE | Directdebitap plicable | VARCHAR2 | 1 | PHINVACCBANKUPLOADTBL |
| DEFAULTFLAG | Defaultflag | VARCHAR2 | 1 | PHINVACCBANKUPLOADTBL |
| ACCOUNTHO LDERNAME | Accountholdername | VARCHAR2 | 100 | PHINVACCBANKUPLOADTBL |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PHINVACCBANKUPLOADTBL |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PHINVACCBANKUPLOADTBL |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PHINVACCBANKUPLOADTBL |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PHINVACCBANKUPLOADTBL |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 20 | PHINVACCBANKUPLOADTBL |
| IBAN | Iban | VARCHAR2 | 40 | PHINVACCBANKUPLOADTBL |
| VERIFICATIONSTATUS | Verificationsta tus | VARCHAR2 | 1 | PHINVACCBANKUPLOADTBL |
| LASTVERIFIEDDATE | Lastverifieddate | DATE | 7 | PHINVACCBANKUPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHINVACCBANKUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHINVESTACCBENFUPLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PHINVESTACCBENFUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHINVESTACCBENFUPLOADTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PHINVESTACCBENFUPLOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHINVESTACCBENFUPLOADTBL |
| BENEFICIARYTYPE | Beneficiarytype | VARCHAR2 | 2 | PHINVESTACCBENFUPLOADTBL |
| BENFPARTYID | Benfpartyid | VARCHAR2 | 16 | PHINVESTACCBENFUPLOADTBL |
| AWARDPERCENTAGE | Awardpercent age | NUMBER | 5 | PHINVESTACCBENFUPLOADTBL |
| BENFPARTYNAME | Benfpartyname | VARCHAR2 | 100 | PHINVESTACCBENFUPLOADTBL |
| DATEOFBIRTH | Dateofbirth | DATE | 7 | PHINVESTACCBENFUPLOADTBL |
| COUNTRYOFBIRTH | Countryofbirth | VARCHAR2 | 3 | PHINVESTACCBENFUPLOADTBL |
| COUNTRYOFDOMICILE | Countryofdomicile | VARCHAR2 | 3 | PHINVESTACCBENFUPLOADTBL |
| GENDER | Gender | VARCHAR2 | 1 | PHINVESTACCBENFUPLOADTBL |
| IDENTIFICATIONTYPE | Identificationtype | VARCHAR2 | 20 | PHINVESTACCBENFUPLOADTBL |
| IDENTIFICATIONNUMBER | Identificationnumber | VARCHAR2 | 50 | PHINVESTACCBENFUPLOADTBL |
| RELATIONSHIP | Relationship | VARCHAR2 | 70 | PHINVESTACCBENFUPLOADTBL |
| ADDRESSLINE1 | Addressline1 | VARCHAR2 | 100 | PHINVESTACCBENFUPLOADTBL |
| ADDRESSLINE2 | Addressline2 | VARCHAR2 | 100 | PHINVESTACCBENFUPLOADTBL |
| CITY | City | VARCHAR2 | 80 | PHINVESTACCBENFUPLOADTBL |
| STATE | State | VARCHAR2 | 80 | PHINVESTACCBENFUPLOADTBL |
| COUNTRY | Country | VARCHAR2 | 3 | PHINVESTACCBENFUPLOADTBL |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PHINVESTACCBENFUPLOADTBL |
| EMAILADDRESS | Emailaddress | VARCHAR2 | 100 | PHINVESTACCBENFUPLOADTBL |
| PRIMARYMOBILENUMBER1 | Primarymobilenumber1 | VARCHAR2 | 60 | PHINVESTACCBENFUPLOADTBL |
| PRIMARYMOBILENUMBER2 | Primarymobilenumber2 | VARCHAR2 | 60 | PHINVESTACCBENFUPLOADTBL |
| PRIMARYFIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PHINVESTACCBENFUPLOADTBL |
| FAX | Fax | VARCHAR2 | 120 | PHINVESTACCBENFUPLOADTBL |
| CONTACTPERSON | Contactperson | VARCHAR2 | 100 | PHINVESTACCBENFUPLOADTBL |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PHINVESTACCBENFUPLOADTBL |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PHINVESTACCBENFUPLOADTBL |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PHINVESTACCBENFUPLOADTBL |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PHINVESTACCBENFUPLOADTBL |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 20 | PHINVESTACCBENFUPLOADTBL |
| ACCOUNTNAME | Accountname | VARCHAR2 | 100 | PHINVESTACCBENFUPLOADTBL |
| IBAN | Iban | VARCHAR2 | 40 | PHINVESTACCBENFUPLOADTBL |
| DESIGNATION | Designation | VARCHAR2 | 100 | PHINVESTACCBENFUPLOADTBL |
| CONTROLLINGPERSON | Controllingperson | VARCHAR2 | 1 | PHINVESTACCBENFUPLOADTBL |
Parent topic: Pension Investment Account (Incremental Upload)