| Data element |
Definition |
ASX_PK
Indexed - yes
Format - number(9)
May be null? no |
The unique row identifier for the ASSET_SECURITY table. |
|
BEN_ID
Indexed - yes
Format - varchar2(100)
May be null? yes |
The BEN Financials ID of the BEN Assets user. |
BEN_RESPONSIBILITY_ID
Indexed - no
Format - number(15)
May be null? yes |
The unique identifier of the BEN responsibility that the user holds. |
BEN_RESPONSIBILITY_NAME
Indexed - no
Format - varchar2(100)
May be null? yes |
The name of the BEN responsibility that the user holds. |
CREATED_DATE
Indexed - no
Format - date
May be null? yes |
The creation date of the record. |
DATA_SOURCE
Indexed - no
Format - varchar2(10)
May be null? yes |
Indicates whether the row was created using DWX, the Warehouse security application, or some other means. |
MANUAL_OVERRIDE
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the automatic inheritance of the record from BEN was overridden. |
ORACLE_ID
Indexed - yes
Format - varchar2(15)
May be null? yes |
The Oracle ID granted access to the Assets data. |
UPDATE_DATE
Indexed - no
Format - date
May be null? yes |
The date the record was last updated. |
WEB_ID
Indexed - yes
Format - varchar2(15)
May be null? yes |
The Penn ID of the individual granted access to the Assets data. |
