| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 3 |
SEQNUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence Number
|
| 4 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number
|
| 5 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
General Ledger Unit
|
| 6 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
1=Actuals
2=Encumbrance
3=Pre-Encumbrance
|
| 7 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
GL Journal ID
|
| 8 |
JOURNAL_DATE |
Date(10) |
DATE |
Journal Date
|
| 9 |
JOURNAL_LINE |
Number(9,0) |
DECIMAL(9) NOT NULL |
GL Journal Line Number
|
| 10 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 11 |
DEPTID_CF |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 12 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
|
| 13 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
|
| 14 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 15 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code
|
| 16 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field.
|
| 17 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field
|
| 18 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit
|
| 19 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 20 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference Chartfield
|
| 21 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield number 1
|
| 22 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 23 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 24 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 25 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 26 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
|
| 27 |
MONETARY_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Monetary Amount
|
| 28 |
FOREIGN_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Foreign Amount
|
| 29 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 30 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 31 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 32 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 33 |
STATISTIC_AMOUNT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Statistic Amount
|
| 34 |
JRNL_LN_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Line Reference
|
| 35 |
OPEN_ITEM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Open Item Status
C=Closed Item
N=Not an Open Item Account
O=Open Item
|
| 36 |
LINE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Journal Line Description
|
| 37 |
JRNL_LINE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Line Status
0=OK - No Errors
1=Uncorrected Error(s)
|
| 38 |
JOURNAL_LINE_DATE |
Date(10) |
DATE |
Journal Line Date
|
| 39 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 40 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 41 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 42 |
ACCOUNTING_DT |
Date(10) |
DATE |
Accounting Date
|
| 43 |
GL_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
D=Distributed
G=Generated
H=Hold
I=Ignored
M=Modified
N=None
|
| 44 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 45 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 46 |
EMPL_RCD_CHAR |
Character(3) |
VARCHAR2(3) NOT NULL |
Empl_rcd# character field
|
| 47 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 48 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 49 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 50 |
USE_DISTRIBUTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Actuals Distribution
|
| 51 |
UPG_HP_RUN_DT |
Date(10) |
DATE |
Run Date
|
| 52 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 53 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 54 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 55 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 56 |
POSITION_POOL_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Position Pool ID
|
| 57 |
SETID_JOBCODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Job Code SetID
|
| 58 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 59 |
BUDGET_DATA |
Character(50) |
VARCHAR2(50) NOT NULL |
Budget Data
|
| 60 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 61 |
DATETIME_STAMP |
DateTime(26) |
TIMESTAMP |
DateTime Stamp
|
| 62 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
|
| 63 |
PAY_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 64 |
OFF_CYCLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Off Cycle ?
|
| 65 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 66 |
COMMIT_ACCTG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Accounting
|
| 67 |
UPG_HP_PRO_INSTNCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 68 |
UPG_DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Convert 'PREPAY' Dedcd to
|
| 69 |
UPG_PARAM1 |
Character(1) |
VARCHAR2(1) NOT NULL |
UPG_PARAM1
|
| 70 |
UPG_PARAM2 |
Character(1) |
VARCHAR2(1) NOT NULL |
UPG_PARAM2
|
| 71 |
PAGE_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Page #
|
| 72 |
LINE_NUM |
Number(2,0) |
SMALLINT NOT NULL |
Line #
|
| 73 |
SEPCHK |
Number(1,0) |
SMALLINT NOT NULL |
Separate check number.
|
| 74 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
|
| 75 |
ERNCD |
Character(3) |
VARCHAR2(3) NOT NULL |
Earnings Code
|
| 76 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 77 |
BENEFIT_PLAN |
Character(6) |
VARCHAR2(6) NOT NULL |
Benefit Plan
|
| 78 |
DEDCD |
Character(6) |
VARCHAR2(6) NOT NULL |
Deduction Code
|
| 79 |
DED_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Classification
A=After-Tax
B=Before-Tax
L=QC Taxable Benefit
N=Nontaxable Benefit
P=Nontaxable Btax Benefit
T=Taxable Benefit
|
| 80 |
DED_SLSTX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Tax Type
B=None
G=Goods and Services Tax
H=Harmonized Sales Tax
I=Provincial Sales Tax Insurance
P=Provincial Sales Tax
Q=QC Prov Sales Tax Insurance
S=QC Provincial Sales Tax
T=Provincial Premium Tax
U=QC Provincial Premium Tax
|
| 81 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
|
| 82 |
LOCALITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Locality
|
| 83 |
TAX_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Tax Balance Class
|
| 84 |
PROVINCE |
Character(6) |
VARCHAR2(6) NOT NULL |
Province
|
| 85 |
TAX_CLASS_CAN |
Character(3) |
VARCHAR2(3) NOT NULL |
Canadian Tax Class
ALL=Total Gross
CBT=Canadian Bonus Tax
CIT=Canadian Income Tax (T4)
CPA=Pension Adjustment
CPP=Canada Pension Plan Employee
CPR=Canada Pension Plan Employer
EIE=Employment Insurance Employee
EIR=Employment Insurance Employer
HTX=Provincial Health Tax
PYT=Payroll Tax
QBT=Quebec Bonus Tax
QCD=Quebec Tax Deduction
QIE=Quebec Parental Plan Employee
QIR=Quebec Parental Plan Employer
QIT=Quebec Income Tax (RL-1)
QPP=Quebec Pension Plan Employee
QPR=Quebec Pension Plan Employer
RV2=Quebec Income Tax (RL-2)
T4A=Canadian Income Tax (T4A)
TRV=True RL
TT4=True T4
|
| 86 |
EMPLID_TO |
Character(11) |
VARCHAR2(11) NOT NULL |
EmplID To
|
| 87 |
EMPL_RCD_OTH |
Number(3,0) |
SMALLINT NOT NULL |
Other Employment Rcd Nbr
|
| 88 |
ACCT_CD_DED |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code (Deductions)
|
| 89 |
POSITION_NBR_HR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number - HR
|
| 90 |
POST_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Post Type
ACR=Academic Responsibility
ADM=Administrative
TTL=Title
|
| 91 |
SETID_1 |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid used to build the Template for entering Bulk Positive Input
|
| 92 |
JOBCODE_PRIOR |
Character(6) |
VARCHAR2(6) NOT NULL |
Prior Jobcode Value
|
| 93 |
HP_DISTRIB_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Actuals Distribution overriden at the Actuals Distribution Panel
|
| 94 |
HP_RETDIST_SEQ_NO |
Number(5,0) |
INTEGER NOT NULL |
Retro Distrubution process sequence number
|