| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ADVANCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Advance ID
Default Value: NEXT
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSONAL_DATA
|
| 3 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
Default Value: %date
|
| 4 |
SUBMISSION_DATE |
Date(10) |
DATE |
Submission Date
|
| 5 |
REFERENCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Reference ID
Prompt Table:
EX_REFERENCE
|
| 6 |
ADVANCE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Advance Description
|
| 7 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 8 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 9 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL
Prompt Table:
SP_BUEX_NONVW
|
| 10 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 11 |
BALANCE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_EX.BASE_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 13 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 14 |
TOTAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Amount
|
| 15 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 16 |
ADV_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Advance Status
APY=Approved for Payment
CLS=Closed
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Auditor
HDA=On Hold, with Approver
HDU=On Hold, with Auditor
HLD=On Hold
PAR=Approvals in Process
PD=Paid
PND=Pending
PRO=In Process
PST=Past Due Balance
RAP=Approved
RCN=Reconciled
RRT=Reroute Transaction
SFA=Submission in Process
STG=Staged
SUB=Submitted for Approval
XML=Submitted, Pending Validation
Default Value: PND
|