| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 4 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 5 |
RUNDATE |
Date(10) |
DATE |
Process Scheduler Run Date
Default Value: %date
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_HR
|
| 7 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 8 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 9 |
DEPT_OFFSET_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Offset Group
Prompt Table:
DEPT_OFFSET_GRP
|
| 10 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 11 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 12 |
DEPTID_NO_EDIT |
Character(10) |
VARCHAR2(10) NOT NULL |
Department ID
Prompt Table:
DEPT_TBL
|
| 13 |
COMMIT_LEVEL |
Number(5,0) |
INTEGER NOT NULL |
Commit Level
Default Value: 100
|
| 14 |
SUCCESS_PCT |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Success Percentage
Default Value: 10
|
| 15 |
START_SUCC_CHK |
Number(6,0) |
INTEGER NOT NULL |
Start Success Checking
Default Value: 10
|
| 16 |
RUN_WITH_ERRORS |
Character(1) |
VARCHAR2(1) NOT NULL |
Run with Errors
Y/N Table Edit
|
| 17 |
BUDGET_RUN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Upload Run Type
F=Fiscal Year
I=Incremental
Default Value: F
|
| 18 |
ADD_TO_FILE |
Character(1) |
VARCHAR2(1) NOT NULL |
Add to Existing File
Y/N Table Edit
Default Value: N
|
| 19 |
BUDGET_LEVEL_INDC |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Level
A=Appointment
D=Department
J=Jobcode
O=Position Pool
P=Position
Default Value: D
|
| 20 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
ACCT_CD_CA_VW
|
| 21 |
BUDGET_OPT_DED |
Character(1) |
VARCHAR2(1) NOT NULL |
Deduction Budget Copy options
C=Copy Previous Dedn Budget
D=Default New Dedn No Benefits
L=Default New Dedn With Benefits
Default Value: L
|
| 22 |
ACCT_CD_DED |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code (Deductions)
Prompt Table:
ACCT_CD_CA_VW
|
| 23 |
BUDGET_OPT_TAX |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Previous Tax Budget
C=Copy Previous Tax Budget
D=Default New Tax Budget
Default Value: D
|
| 24 |
ACCT_CD_TAX |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code (Tax)
Prompt Table:
ACCT_CD_CA_VW
|
| 25 |
GL_RELEASE_NO |
Character(3) |
VARCHAR2(3) NOT NULL |
This indicator is to identify the Financial System that HRMS will interface to.
700=7.00
701=7.01
750=7.5
800=8.00
840=8.40
841=8.41
880=8.80
890=8.90
C=7.5
P=7
Default Value: 840
|
| 26 |
RUNLOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Location
0=Both
1=Client
2=Server
Default Value: 1
|
| 27 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 28 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 29 |
DIST_PRORATE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Prorate Option
C=Calendar Days
I=For Internal System Use Only
N=Not Applicable
W=Work Days
Default Value: C
|
| 30 |
HP_FRINGE_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Fringe Group
Prompt Table:
HP_FRINGE_GROUP
|
| 31 |
HP_REDIRECT_ACCT |
Character(25) |
VARCHAR2(25) NOT NULL |
Redirect Account Code
Prompt Table:
HP_REDIRECT_VW
|
| 32 |
HP_ERN_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Acct Defined for Earnings
Y/N Table Edit
Default Value: Y
|
| 33 |
HP_DED_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Acct Defined for Dedns
Y/N Table Edit
Default Value: Y
|
| 34 |
HP_TAX_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Acct Defined for US Tax
Y/N Table Edit
Default Value: Y
|
| 35 |
BUDGET_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget Period
Prompt Table:
CAL_BP_VW
|