Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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? 

Accounting period start date.

221 - First Acct. Date to Reopen

REQUIRED

DATE 

Ending of period date for

Statements

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? 

Bypass duplicate event check.

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.