Versions Compared

Key

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


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

Accounting basis.

920 - Accounting Period Start Date

REQUIRED

  

DATE (99)

Accounting period start date.

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

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.