| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
Default Value: NEXT
|
| 4 |
VERSION_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Version Number
Default Value: 1
|
| 5 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 6 |
PERIOD_END_DT |
Date(10) |
DATE NOT NULL |
Represents the date termination point for a given time set utilized in cash worksheet processing.
|
| 7 |
TIME_SHEET_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Time Sheet Status
ADJ=Adjusted
APR=Approved
DEN=Denied
DNA=Denied by Approver
DNU=Denied by Project Manager
HDA=Hold by Approver
HDU=Hold by Project Manager
HLD=Hold
MFS=Marked for Submit
PAR=Approvals in Process
PND=Pending
PRO=In Process
SFA=Submission in Process
SUB=Submitted for Approval
XML=Submitted, Pending Validation
Default Value: PND
|
| 8 |
POST_STATUS_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses Post Status
C=Closed
M=Marked for Unpost
N=Not Applied
O=Unpost In Process
P=Posted
S=Close In Process
U=Unposted
Default Value: N
|
| 9 |
EX_ORIGIN |
Character(1) |
VARCHAR2(1) NOT NULL |
Origin of Entry (Expenses)
A=Asset Lifecycle Management
H=Mobile Hand Held Device
M=Mobile Time and Expense
N=NUI
P=Primavera P6
W=Web
Default Value: W
|
| 10 |
APPROVAL_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Level
A=Approver Only
B=Pre- and Post-Pay Audit
E=Approver & Pre-Pay Auditor
I=Approve, Pre- & Post-Pay Audit
N=None
S=Approver & Post-Pay Auditor
T=Auditor Only - Post-Payment
U=Auditor Only - Pre-Payment
|
| 11 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
Default Value: %date
|
| 12 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 13 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 14 |
AUDIT_DT |
Date(10) |
DATE |
Date of Audit
|
| 15 |
AUDIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The OPRID of the user who made the changes audited on an audit record.
|
| 16 |
SUBMISSION_DATE |
Date(10) |
DATE |
Submission Date
|
| 17 |
SUBMIT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Report Submitted By - Character (30)
|
| 18 |
RESUBMISSION_DT |
Date(10) |
DATE |
Resubmission Date
|
| 19 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 20 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
Default Value: EX_AA_EE_ORG_VW.BUSINESS_UNIT_GL
|
| 21 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Default Value: EX_AA_EE_ORG_VW.DEPTID
|
| 22 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: EX_AA_EE_ORG_VW.EMPL_RCD
|
| 23 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 24 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
Default Value: N
|
| 25 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 26 |
PROJ_MGR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Manager Review
Default Value: N
|
| 27 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
COUNTRY_TBL
|
| 28 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 29 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 30 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
Prompt Table:
LOCAL_TAX_VW
|
| 31 |
BILLING_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Billing Action
B=Billable
I=Internal
P=Personal
U=Nonbillable
Default Value: B
|
| 32 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 33 |
OPRID_SUBMITTED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator Id of user submitting the transaction
|
| 34 |
ACKNOWLEDGE_DTTM |
DateTime(26) |
TIMESTAMP |
Acknowledge Date Time
|
| 35 |
DTL_TOTAL |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Total
|
| 36 |
POL_TOTAL |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
PolTotal
|
| 37 |
VERSION_LBL |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to show version in search pages
O=Original Version
P=Partial Submit
R=Revision
|
| 38 |
APPR_PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval in Process Flag
Y/N Table Edit
Default Value: N
|
| 39 |
DATE_TIME_HM |
DateTime(26) |
TIMESTAMP |
Date Timestamp
|
| 40 |
OPRID_LAST_ACTION |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Take Action
|
| 41 |
ACTION_NAME |
Character(3) |
VARCHAR2(3) NOT NULL |
Action taken on a transaction
APR=Approved
AUT=Auto Approved
BUD=Budget Checked
DEL=Deleted
DNY=Denied
HLD=On Hold
PAS=Post Approval Submit
REC=Receipt Verified
RES=Resubmitted
REV=Reviewed
RSN=Reassigned
SBR=Sent Back For Revision
SUB=Submitted
WDR=Withdrawn
|
| 42 |
OUT_OF_POLICY |
Character(1) |
VARCHAR2(1) NOT NULL |
Authorized Amount Exceeded
Y/N Table Edit
Default Value: N
|
| 43 |
RISK_EXISTS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Risk Exists
Y/N Table Edit
Default Value: N
|
| 44 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|