EXP_CLASS 
Default Table Name  EXP_CLASS 
Definition 
 Name: Expense Report Class.     Description: This table contains the user defined expense report classes.
 

EXP_CLASS Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EXP_CLASS_CD(PK)    VARCHAR2(20)  NO 
Name: Expense Class. Description: User-specified unique identifier for employee expense class table.
 
EXP_CLASS_DESC    VARCHAR2(30)  NO 
Name: Expense Class Description. Description: Unique description of employee expense class.
 
MODIFY_EXCHANGE_RATE_FL    VARCHAR2(1)  NO 
Name: Modify Exchange Rate. Description: Logical as to whether employees of this class can modify system defaulted exchange rates.
 
MODIFIED_BY    VARCHAR2(20)  NO 
Name: Modified By. Description: The User ID of the person who last modified this record.
 
ROWVERSION    NUMBER(10, 0)  NO 
Name: Row Version. Description: The number of times this record has been updated.
 
TIME_STAMP    DATE  NO 
Name: Time Stamp. Description: Date and time the record was last modified.
 
S_REVISION_CD    VARCHAR2(20)  NO 
Name: Revision Explanation Option. Description: The revision explanation options that are valid for employees assigned to this expense class. The valid options are as follows:DISABLED. OPTIONAL. REQUIRED. 
 
VOID_DRAFT_FL    VARCHAR2(1)  NO 
Name: ER Void Draft Flag. Description: Logical as to whether draft expense reports can be voided for this class.
 
VOID_SIGNED_FL    VARCHAR2(1)  NO 
Name: ER Void Signed Flag. Description: Logical as to whether signed expense reports can be voided for this class.
 
VOID_UNDER_REVIEW_FL    VARCHAR2(1)  NO 
Name: ER Void Under Review Flag. Description: Logical as to whether under review expense reports can be voided for this class.
 
VOID_APPROVED_FL    VARCHAR2(1)  NO 
Name: ER Void Approved Flag. Description: Logical as to whether approved expense reports can be voided for this class.
 
VOID_REJECTED_FL    VARCHAR2(1)  NO 
Name: ER Void Rejected Flag. Description: Logical as to whether rejected expense reports can be voided for this class.
 
MODIFY_TAX_FL    VARCHAR2(1)  NO 
Name: Modiy Tax Amount Flag. Description: Logical as to whether employees of this class can modify system calculated tax.
 
VOID_AUTH_DRAFT_FL    VARCHAR2(1)  NO 
Name: EA Void Draft Flag. Description: Logical as to whether draft authorizations can be voided for this class.
 
VOID_AUTH_SIGNED_FL    VARCHAR2(1)  NO 
Name: EA Void Signed Flag. Description: Logical as to whether signed authorizations can be voided for this class.
 
VOID_AUTH_UNDER_REVIEW_FL    VARCHAR2(1)  NO 
Name: EA Void Under Review Flag. Description: Logical as to whether under review authorizations can be voided for this class.
 
VOID_AUTH_APPROVED_FL    VARCHAR2(1)  NO 
Name: EA Void Approved Flag. Description: Logical as to whether approved authorizations can be voided for this class.
 
VOID_AUTH_REJECTED_FL    VARCHAR2(1)  NO 
Name: EA Void Rejected Flag. Description: Logical as to whether rejected authorizations can be voided for this class.
 
CASH_ADVANCE_LIMIT_AMT    NUMBER(15, 5)  NO 
Name: Cash Advance Limit. Description: The cash advance limit for employees of this class to have as outstanding. A limit of zero or the employee exceeding limit means employees of this cash can not request cash advances. The amount is in the system’s base currency.
 
OUTSTANDING_CASH_ADVANCE_NO    NUMBER(10, 0)  NO 
Name: Outstanding # of Cash Advance Limit. Description: Number of cash advances the employee can have outstanding at any one time.
 
MODIFY_SIGNED_FL    VARCHAR2(1)  NO 
Name: Modify Signed ER Flag. Description: Logical as to whether signed expense reports can be modified for this class.
 
MODIFY_UNDER_REVIEW_FL    VARCHAR2(1)  NO 
Name: Modify Under Review ER Flag. Description: Logical as to whether under review expense reports can be modified for this class.
 
MODIFY_APPROVED_FL    VARCHAR2(1)  NO 
Name: Modify Approved ER Flag. Description: Logical as to whether approved expense reports can be modified for this class.
 
MODIFY_AUTH_SIGNED_FL    VARCHAR2(1)  NO 
Name: Modify Signed EA Flag. Description: Logical as to whether signed expense authorizations can be modified for this class.
 
MODIFY_AUTH_UNDER_REVIEW_FL    VARCHAR2(1)  NO 
Name: Modify Under Review EA Flag. Description: Logical as to whether under review expense authorizations can be modified for this class.
 
MODIFY_AUTH_APPROVED_FL    VARCHAR2(1)  NO 
Name: Modify Approved EA Flag. Description: Logical as to whether approved expense authorizations can be modified for this class.
 
CP_PROJECT_LOOKUP_FL    VARCHAR2(1)  NO 
Name: CP Charge Lookup Project Flag. Description: Logical as to whether Costpoint Charge Lookup should have a Project Tab.
 
CP_MO_LOOKUP_FL    VARCHAR2(1)  NO 
Name: CP Charge Lookup MO Flag. Description: Logical as to whether Costpoint Charge Lookup should have a MO Tab
 
CP_ACCOUNT_LOOKUP_FL    VARCHAR2(1)  NO 
Name: CP Charge Lookup Account Flag. Description: Logical as to whether Costpoint Charge Lookup should have an Account Tab.
 
S_CORRECTION_CD    VARCHAR2(1)  NO 
Name: Correction Code. Description: Determines whether employees with this class can perform expense report corrections and what type can be performed. Valid values are: 0 – not allowed,1 – Net Zero Only,2 – All Corrections Allowed.
 
DAYS_PAST_EXP_RPT_NO    NUMBER(3, 0)  NO 
Name: Days Past Expense Report Date. Description: Number of days past the expense report’s date that corrections can be performed.
 
ACTIVE_CHARGES_ONLY_FL    VARCHAR2(1)  NO 
Name: Active Charges Only. Description: Determines whether only expense reports with active charges can be corrected.
 
S_ER_INTERIM_SIGNATURE_CD    VARCHAR2(1)  NO 
Name: Notify Interim Signature   Description: Logical as to whether or not the system shall send notification when an interim signature is completed on the expense report. Valid values are: O for Owner and N for None.
 
S_ER_APPROVE_CD    VARCHAR2(1)  NO 
Name: Notify ER Approval   Description: Logical as to whether or not the system shall send notification when an expense report has been approved. Valid values are: O for Owner and N for None.
 
S_ER_REVISE_CD    VARCHAR2(1)  NO 
Name: Notify ER Revised   Description: Logical as to whether or not the system shall send notification when an expense report has been revised. Valid values are: O for Owner and N for None.
 
S_ER_REJECT_CD    VARCHAR2(1)  NO 
Name: Notify ER Rejected   Description: Logical as to whether or not the system shall send notification when an expense report has been rejected. Valid values are: O for Owner and N for None.
 
S_ER_VOID_CD    VARCHAR2(1)  NO 
Name: Notify ER Voided   Description: Logical as to whether or not the system shall send notification when an expense report has been voided. Valid values are: O for Owner and N for None.
 
S_ER_PAID_CD    VARCHAR2(1)  NO 
Name: Notify ER Paid   Description: Logical as to whether or not the system shall send notification when an expense report has been paid. Valid values are: O for Owner and N for None.
 
S_ER_CHARGE_APPROVE_CD    VARCHAR2(1)  NO 
Name: Notify ER Charge Approved    Description: Logical as to whether or not the system shall send notification when a charge has been approved on an expense report. Valid values are: O for Owner and N for None.
 
S_ER_CHARGE_REJECT_CD    VARCHAR2(1)  NO 
Name: Notify ER Charge Rejected   Description: Logical as to whether or not the system shall send notification when a charge has been rejected on an expense report. Valid values are: O for Owner and N for None.
 
S_ER_ATTACHMENT_ATTACH_CD    VARCHAR2(1)  NO 
Name: Notify ER Attachment Attached   Description: Logical as to whether or not the system shall send notification when an attachment has been attached to an expense report. Valid values are: O for Owner and N for None.
 
S_ER_ATTACHMENT_RECORD_CD    VARCHAR2(1)  NO 
Name: Notify ER Attachment Recorded   Description: Logical as to whether or not the system shall send notification when an attachment has been recorded on an expense report. Valid values are: O for Owner and N for None.
 
S_ER_ATTACHMENT_APPROVE_CD    VARCHAR2(1)  NO 
Name: Notify ER Attachment Approved   Description: Logical as to whether or not the system shall send notification when an attachment has been approved on an expense report. Valid values are: O for Owner and N for None.
 
S_ER_ATTACHMENT_REJECT_CD    VARCHAR2(1)  NO 
Name: Notify ER Attachment Rejected   Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense report. Valid values are: O for Owner and N for None.
 
S_ER_EXPENSE_IMPORT_CD    VARCHAR2(1)  NO 
Name: Notify Expense Imported   Description: Logical as to whether or not the system shall send notification when an expense has been imported for an employee in this class. Valid values are: O for Owner and N for None.
 
S_EA_INTERIM_SIGNATURE_CD    VARCHAR2(1)  NO 
Name: Notify Interim Signature   Description: Logical as to whether or not the system shall send notification when an interim signature is completed on the expense authorization. Valid values are: O for Owner and N for None.
 
S_EA_APPROVE_CD    VARCHAR2(1)  NO 
Name: Notify EA Approved   Description: Logical as to whether or not the system shall send notification when an expense authorization has been approved. Valid values are: O for Owner and N for None.
 
S_EA_REVISE_CD    VARCHAR2(1)  NO 
Name: Notify EA Revised   Description: Logical as to whether or not the system shall send notification when an expense authorization has been revised. Valid values are: O for Owner and N for None.
 
S_EA_REJECT_CD    VARCHAR2(1)  NO 
Name: Notify EA Rejected   Description: Logical as to whether or not the system shall send notification when an expense authorization has been rejected. Valid values are: O for Owner and N for None.
 
S_EA_VOID_CD    VARCHAR2(1)  NO 
Name: Notify EA Voided   Description: Logical as to whether or not the system shall send notification when an expense authorization has been voided. Valid values are: O for Owner and N for None.
 
S_EA_CHARGE_APPROVE_CD    VARCHAR2(1)  NO 
Name: Notify EA Charge Approved   Description: Logical as to whether or not the system shall send notification when a charge has been approved on an expense authorization. Valid values are: O for Owner and N for None.
 
S_EA_CHARGE_REJECT_CD    VARCHAR2(1)  NO 
Name: Notify EA Charge Rejected   Description: Logical as to whether or not the system shall send notification when a charge has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 
S_EA_ATTACHMENT_ATTACH_CD    VARCHAR2(1)  NO 
 
S_EA_ATTACHMENT_RECORD_CD    VARCHAR2(1)  NO 
Name: Notify EA Attachment Recorded   Description: Logical as to whether or not the system shall send notification when an attachment has been recorded on an expense authorization. Valid values are: O for Owner and N for None.
 
S_EA_ATTACHMENT_APPROVE_CD    VARCHAR2(1)  NO 
Name: Notify EA Attachment Approved   Description: Logical as to whether or not the system shall send notification when an attachment has been approved on an expense authorization. Valid values are: O for Owner and N for None.
 
S_EA_ATTACHMENT_REJECT_CD    VARCHAR2(1)  NO 
Name: Notify EA Attachment Rejected    Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 
S_ADVANCE_APPROVE_CD    VARCHAR2(1)  NO 
Name: Notify Advance Approved   Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 
S_ADVANCE_REJECT_CD    VARCHAR2(1)  NO 
Name: Notify Advance Rejected   Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 
S_ADVANCE_PAID_CD    VARCHAR2(1)  NO 
Name: Notify Advance Paid   Description: Logical as to whether or not the system shall send notification when an attachment has been rejected on an expense authorization. Valid values are: O for Owner and N for None.
 
S_ADVANCE_REQUEST_CD    VARCHAR2(10)  NO 
 

EXP_CLASS Primary and Unique Keys 
Key Name  Key Type  Keys 
PI_0146  PrimaryKey  EXP_CLASS_CD 

EXP_CLASS Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable 
EMPL_HISTORY  Non-Identifying  One To Zero or More  F00149        NO  NO 
EXP_CLASS_EXP_RPT_TYPE  Identifying  One To Zero or More  F00159        NO  NO 
EXP_CLASS_PAY_METHOD  Identifying  One To Zero or More  F00161        NO  NO 
EXP_CONFIG  Non-Identifying  One To Zero or More  F00201        NO  NO 
EXP_RPT  Non-Identifying  One To Zero or More  F00208        NO  NO 
EXP_AUTH  Non-Identifying  One To Zero or More  F00352        NO  NO