Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ROLES TRANSACTIONS Table


XXX


Field Name

Description

Data Type

Length

ACTION_TYPE

XXX

VARCHAR2

1

DESCEND

XXX

VARCHAR2

1

DO_FUNCTION

XXX

VARCHAR2

1

EFFECTIVE_DATE

In the COST COLLECTOR table: this represents the effective date or starting date of the fund cost collector. In the ASA OFFICER DETAIL table this is the starting date of the tenure of the officer.

DATE

EXPIRATION_DATE

In the COST COLLECTOR table: Final or expiration date of the fund cost collector. In the ASA OFFICER DETAIL table, this is the date when the officer's term expires.

DATE

FUNCTION_CATEGORY_CODE

XXX

VARCHAR2

4

GRANT_AND_VIEW

XXX

VARCHAR2

2

KRB_NAME

Kerberos Name

VARCHAR2

8

MODIFIED_BY

XXX

VARCHAR2

8

MODIFIED_DATE

XXX

DATE

ROLES_FUNCTION_KEY

XXX

NUMBER

ROLES_QUALIFIER_KEY

XXX

NUMBER

12