ASSET_CATEG_IDRBW_HOLDING_C_V(SQL View) |
Index Back |
|---|---|
Checking HoldingThis view displays Checking holdings of a person in wealth management |
| SELECT ' ' , ' ' ,' ' , ' ' ,' ' ,' ' ,' ' ,%CurrentDateOut , 0 ,' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSET_CATEG_ID |
Character(15) | VARCHAR2(15) NOT NULL | This field is the primary key for Asset category table |
| 2 | ASSET_TYPE2 | Character(4) | VARCHAR2(4) NOT NULL | This is the asset type2 of the asset category table. |
| 3 | ASSET_TYPE3 | Character(4) | VARCHAR2(4) NOT NULL | This is the asset type3 of the asset category table. |
| 4 | STOCK_SYMBOL | Character(10) | VARCHAR2(10) NOT NULL | This field is used to store the Stock Symbol |
| 5 | FIN_ACCOUNT_ID | Character(20) | VARCHAR2(20) NOT NULL | Financial Account Number |
| 6 | REGISTRATION_NAME | Character(50) | VARCHAR2(50) NOT NULL | Registration Name --------> FSI Account |
| 7 | WHERE_HELD | Character(50) | VARCHAR2(50) NOT NULL | Institution at which a certain asset is held |
| 8 | BEGIN_DATE | Date(10) | DATE | Begin Date |
| 9 | STOCK_QTY | Number(21,4) | DECIMAL(20,4) NOT NULL | This field is used to define the quantity of stock that a client owns. |
| 10 | CUST_ACCT_NBR | Character(20) | VARCHAR2(20) NOT NULL | This is the Customer defined Account Number for a financial account |