| # |
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
Default Value: RUN_CNTL_BLOAD.RUN_CNTL_ID
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SETID_TBL
|
| 4 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPARTMENT_SRCH
|
| 5 |
ACCT_CD |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code
Prompt Table:
ACCT_CD_CA_VW
|
| 6 |
ACCT_CD_DED |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code (Deductions)
Prompt Table:
ACCT_DED_VW
|
| 7 |
ACCT_CD_TAX |
Character(25) |
VARCHAR2(25) NOT NULL |
Combination Code (Tax)
Prompt Table:
ACCT_TAX_VW
|
| 8 |
DEPT_OFFSET_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Department Offset Group
Prompt Table:
DEPT_OFFSET_GRP
|
| 9 |
BUDGET_LEAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Leave Flag
Y/N Table Edit
Default Value: N
|
| 10 |
BUD_LEVELS_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Level Option selection for the initial creation of the Department Budget table (BUD005).
1=Position and Appointment
2=Dept, Position and Appointment
3=Department Only
4=Department and Position
5=Department and Position Pool
Default Value: 2
|
| 11 |
POPULATE_BUD_AMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Option to populate the Budget Amount field on the Department Budget Earnings table (as opposed to the percentage distribution field) during the initial creation of the Department Budget tables (BUD005).
Y/N Table Edit
Default Value: N
|
| 12 |
PERCENT_INCREASE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percent Increase (or decrease) to be applied during the initial creation of Department Budget tables (BUD005).
|
| 13 |
HP_ACCT_CD_SUSPNS |
Character(25) |
VARCHAR2(25) NOT NULL |
Suspense Account Code
Prompt Table:
ACCT_CD_CA_VW
|
| 14 |
HP_FRINGE_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Fringe Group
Prompt Table:
HP_FRINGE_GROUP
|
| 15 |
HP_REDIRECT_ACCT |
Character(25) |
VARCHAR2(25) NOT NULL |
Redirect Account Code
Prompt Table:
HP_REDIRECT_VW
|
| 16 |
HP_ERN_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Acct Defined for Earnings
Y/N Table Edit
Default Value: Y
|
| 17 |
HP_DED_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Acct Defined for Dedns
Y/N Table Edit
Default Value: Y
|
| 18 |
HP_TAX_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Acct Defined for US Tax
Y/N Table Edit
Default Value: Y
|