Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Travel And Expense Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AE_PROFILE

Description Contains data pertaining to a user's profile.
Key & Frequency One row per profile.

Target Column Business Definition Database Data Type Source Name Source Column
APPROVER_UID Personal identification number of the workflow approver who approves documents for this expense owner. NUMBER

FTOBPROF

APPROVER_PIDM

CURRENT_DATE This is a the system current date (sysdate). DATE

NA

SYSDATE

DELEGATE_IND   VARCHAR2(1)    
DELEGATE_TRAVELER_REVIEW_IND   CHAR(1)    
DIRECT_DEPOSIT_IND Determines if the address used indicates direct deposit. (Y)es, use direct deposit, (N)o, create check. VARCHAR2(1)

FUNCTION

GOKODSF.F_DIRECT_DEPOSIT_IND

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

EMAIL_ADDRESS Email address of the expense owner as contact information for workflow approvals. VARCHAR2(128)

FTOBPROF

DEFAULT_EMAIL_ADDRESS

HOME_CAMPUS Home campus associated to the expense owner. VARCHAR2(3)

FTOBPROF

HOME_CAMPUS

HOME_COAS Home Chart of Accounts used with the organization to uniquely define the department the expense owner typically reports to. VARCHAR2(1)

FTOBPROF

HOME_COAS

HOME_ORGN Home Organization representing the department that the expense owner typically reports to. Used with approval to determine department routings. VARCHAR2(6)

FTOBPROF

HOME_ORGN

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NON_RESIDENT_ALIEN_IND Indicates if the person is a non resident alien. VARCHAR2(1)

FTOBPROF

NON_RESIDENT_ALIEN_IND

PERSON_UID Personal identification number of the person who owns this profile. NUMBER

FTOBPROF

OWNER_PIDM

PROFILE_ACTIVITY_DATE Date information for this record in the table was entered or last updated. DATE

FTOBPROF

ACTIVITY_DATE

PROFILE_DATA_ORIGIN Source system that created or updated the data. VARCHAR2(30)

FTOBPROF

DATA_ORIGIN

PROFILE_KEY Unique internal identification number of the expense profile record. NUMBER

FTOBPROF

ID

PROFILE_USER_ID Unique identification code of the user who entered or last touched the record. VARCHAR2(30)

FTOBPROF

USER_ID

REMIT_ADDRESS_DESC Description for the type of address used as the default for payment to the expense owner. VARCHAR2(30)

STVATYP

STVATYP_DESC

REMIT_ADDRESS_NUMBER Sequence number used to identify different addresses within the same address type for the expense owner. NUMBER

FTOBPROF

DEFAULT_ATYP_SEQ_NUM

REMIT_ADDRESS_TYPE Type of address used as the default for payment to the expense owner. VARCHAR2(2)

FTOBPROF

DEFAULT_ATYP_CODE

WORKFLOW_USER_LOGON Common login identification used to signon into Workflow. This is used to map the profile to a workflow signon in order to pass the document information to workflow for approvals. VARCHAR2(255)

FTOBPROF

WORKFLOW_USER_LOGON

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: