Penn Computing

University of Pennsylvania
Penn Computing << go backback
CT_ROLE Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home

CT_ROLE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
FEAT_KEY

Indexed - no
Format - char(3)
May be null? yes

Code for the Concur module feature to which the role applies.

IS_ASSIGNABLE_ROLE

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the role is assignable.
IS_GROUP_ROLE

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the role may be used for groups.
IS_WORKFLOW_ROLE

Indexed - no
Format - char(1)
May be null? yes
Indicates whether the role is used in workflow.
PROD_CODE

Indexed - no
Format - varchar2(3)
May be null? yes
Code for the Concur module to which the role applies.
ROLE_CODE

Indexed - yes
Format - varchar2(15)
May be null? no
Code  that uniquely identifies a user system role within Concur.
ROLE_CODE_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the role code record was last modified.
ROLE_DESCRIPTION

Indexed - no
Format - varchar2(256)
May be null? yes
Description of the user system role.
ROLE_NAME

Indexed - no
Format - varchar2(64)
May be null? yes
Name of the user system role within Concur.
ROLE_NAME_LAST_MODIFIED

Indexed - no
Format - date
May be null? yes
Date on which the role name was last modified.

CT_ROLE Table   Tables and Data Elements   Travel & Expense Management Home    Data Warehouse Home


Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania