| Data element |
Definition |
CA_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies a cash advance. |
CAN_CARRY_OVER
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the cash advance is allowed to carry over to more than one expense report. |
CASH_ADVANCE_NAME
Indexed - no
Format - varchar2(40)
May be null? yes |
Employee-entered name of the cash advance. |
CRN_KEY
Indexed - yes
Format - number
May be null? yes |
Employee's reimbursement currency. |
CURRENT_WORKFLOW
Indexed - no
Format - number
May be null? no |
Indicates whether this is the workflow instance through which the transaction is currently progressing. A single transaction may have more than one associated workflow instance, but only one will be active or current. For example, if an expense report is sent back to the employee, that terminates one workflow instance. When the employee resubmits the report, that action initiates a new workflow instance. |
EMP_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies the employee requesting or taking the cash advance. |
EXCHANGE_RATE
Indexed - no
Format - number
May be null? yes |
Exchange rate of the cash advance currency. |
HIER_NODE_KEY
Indexed - yes
Format - number
May be null? yes |
|
ISSUED_DATE
Indexed - no
Format - date
May be null? yes |
Date the cash advance was issued. |
LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the cash advance record was last modified. |
PAT_KEY
Indexed - yes
Format - char(4)
May be null? yes |
Payment type used to issue the cash advance. A credit card payment type indicates that the employee took a cash advance on their credit card. |
PERSON_HOME_ORG
Indexed - yes
Format - varchar2(4)
May be null? yes |
4-digit number used to identify the organization that owns the employee's record and is responsible for its maintenance in the PennWorks system. |
PERSON_HOME_SCHOOL_CTR
Indexed - yes
Format - varchar2(2)
May be null? yes |
2-digit number used to identify the school or center that owns the employee's record and is responsible for its maintenance in the PennWorks system. |
PERSON_PENN_ID
Indexed - yes
Format - varchar2(8)
May be null? yes |
8-digit identification number assigned to the person by the Penn Community system. |
REQUEST_AMOUNT
Indexed - no
Format - number
May be null? yes |
Amount of the cash advance. |
REQUEST_CRN_KEY
Indexed - yes
Format - number
May be null? yes |
The currency of the cash advance request. |
REQUEST_DATE
Indexed - no
Format - date
May be null? yes |
Date the submitter made the cash advance request. |
STAT_KEY
Indexed - yes
Format - char(6)
May be null? yes |
Status of the cash advance in the approval and authorization process. |
SUBMITTED_BALANCE
Indexed - no
Format - number
May be null? yes |
Amount of the cash advance used on submitted expense reports. |
UNSUBMITTED_BALANCE
Indexed - no
Format - number
May be null? yes |
Amount of the issued cash advance, less the amount of cash advance used on submitted expense reports. |
