Please review/provide values for cells with ??NG (in red)
A field to specify choice of name, symbol, asset, pool​
| Tag # - Tag Name | Required/Optional | Data Type | Value/Description of Field |
|---|---|---|---|
| 2283 - Select Query Option | REQUIRED | CHAR | User defined. |
| 1163 - Entity ID | OPTIONAL | CHAR (8) | Lookup on the Entity ID. |
| 1164 - Entity Name | OPTIONAL | CHAR (30) | Lookup on the Entity Name. |
| 5 - Account | OPTIONAL | CHAR | Account or portfolio Identifier. |
| 3953 - Port Comp Type | OPTIONAL | CHAR | Identifies the portfolio or composite type. |
| 21 - Accounting Basis | OPTIONAL | VARCHAR2(5) | Accounting basis. |
| 920 - Accounting Period Start Date | REQUIRED | DATE (99) | ??NG description to be added? |
| 221 - First Acct. Date to Reopen | REQUIRED | DATE | Ending of period date for Statements. |
| 1257 - Type of Close | REQUIRED | CHAR | A field to indicate the type of corporate action such as "sdiv", "merg". |
| 2816 - Archive Date | OPTIONAL | DATE | Date of the most recent purge/archive for a basis. |
| 4896 - Process Center | OPTIONAL | VARCHAR2 (2) | Lookup based on Process Center. |
| 3914 - Conversion Status | OPTIONAL | CHAR | Indicates the current status of the fund. |
| 1256 - Query Based On | OPTIONAL | CHAR | A field to specify choice of name, symbol, asset, pool. |
| 988 - Bypass Dup Event Check | OPTIONAL | CHAR | ??NG description to be added? |
| 30 - Post Date | OPTIIONAL | DATE | The date the event was processed. Usually process date is current date. |
| 55 - Event Type | REQUIRED | CHAR | The business intent of the event. Used as the primary determinant in the accounting plan identification process. |
| 95 - Partition | REQUIRED | INTEGER | The partition of a database where a position resides. |
| 98 - Source System | REQUIRED | CHAR | The originating source system identifier. |
| 9187 - Operation Switch | OPTIONAL | CHAR | Operation switch. |
| 9403 - Rejection Source | OPTIONAL | CHAR | Rejection source. |
| 944 - Update Source | OPTIONAL | CHAR | The source or userid of the entity that last updated the table. |
Add Comment