| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
|
| 3 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 4 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 5 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 7 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 8 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 9 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 10 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 11 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 12 |
UPG_RELEASE |
Character(4) |
VARCHAR2(4) NOT NULL |
Upgrade Application Release
751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release
|
| 13 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Exist
|
| 14 |
EXIST2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Exist2
|
| 15 |
EXIST3 |
Character(1) |
VARCHAR2(1) NOT NULL |
Exist3
|
| 16 |
EXIST4 |
Character(1) |
VARCHAR2(1) NOT NULL |
Exist 4
|
| 17 |
EXISTS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists Flag - Indicates presence in Asset Repository
D=Duplicate
Y=Exists in ARM
|
| 18 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 19 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 20 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 21 |
TRAVEL_AUTH_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Travel Authorization Identification. Number used to define travel authorizations. Key field on most travel authorization records and exists at level 0 for travel authorization panels.
|
| 22 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 23 |
TIME_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Time Quantity
|
| 24 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 25 |
ENFORCE_BGTCHK_EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Require budget checking prior to approval for expense reports
|
| 26 |
ENFORCE_BGTCHK_TA |
Character(1) |
VARCHAR2(1) NOT NULL |
Require budget checking prior to approval for travel authorizations.
|
| 27 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 28 |
VERSION_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Version Number
|
| 29 |
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
|
| 30 |
REF_TIME_SHEET_ADJ |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 31 |
DESCR60 |
Character(60) |
VARCHAR2(60) NOT NULL |
Description
|
| 32 |
TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code
|
| 33 |
DATE_UNDER_RPT |
Date(10) |
DATE |
Date Under Report
|
| 34 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 35 |
APPROVAL_DT |
Date(10) |
DATE |
Date of Approval
|
| 36 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 37 |
APPROVAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved
D=Denied
E=Sent Back for Revision
H=On Hold
I=Initial
M=Resubmitted
P=In Process
R=Rerouted
S=Submitted
|
| 38 |
APPROVER_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines types of approvers, including originator, regular approver and auditor.
A=Approver
O=Originator
P=Project Manager
T=Post-Pay Auditor
U=Pre-Pay Auditor
|
| 39 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 40 |
ADVANCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Advance ID
|
| 41 |
CFSTRING1 |
Long Character(1000) |
VARCHAR2(1000) |
ChartField String
|
| 42 |
CFSTRING2 |
Long Character(1000) |
VARCHAR2(1000) |
ChartField String
|
| 43 |
VS_CCTRANS_NBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Transaction Number
|
| 44 |
VS_REFERENCENBR |
Character(24) |
VARCHAR2(24) NOT NULL |
Effective Date
|
| 45 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 46 |
IS_INFORMIX |
Character(1) |
VARCHAR2(1) NOT NULL |
This field must identify if the process is being executed in Informix.
Y/N Table Edit
Default Value: N
|
| 47 |
AE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Exists
|
| 48 |
PRIVILEGE_TMPL_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Privilege Template Id. Contains the name of the privilege template.
|
| 49 |
DFLT_ACCTG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Accounting Flag.
H=Hide
M=Modify
V=View
|
| 50 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 51 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|