| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPERATOR_VW
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 4 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 5 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table:
SET_DEPT_VLD_VW
|
| 6 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERS_SRCH_GBL
|
| 7 |
LIST_OPTION_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
List Option
1=All Establishments & Employees
2=By Establishment ID
3=By Employee ID
4=Select Group ID
5=Select Pay Group
6=Hire Date
7=Changes Only
Default Value: 1
|
| 8 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 9 |
END_DT |
Date(10) |
DATE |
end date
|
| 10 |
CHG_DEP_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Report changes on department
Y/N Table Edit
Default Value: N
|
| 11 |
CHG_EST_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Report changes on establishment
Y/N Table Edit
Default Value: N
|
| 12 |
CHG_JOBCD_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Report changes on job code
Y/N Table Edit
Default Value: N
|
| 13 |
CHG_JOBPOS_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Report changes on job position
Y/N Table Edit
Default Value: N
|
| 14 |
CHG_SAL_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Report changes on salary
Y/N Table Edit
Default Value: N
|
| 15 |
COMMENTS_OPT_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Comments Options => Employee Registry BRA
1=No Comments
2=Print Comments
3=Print Box
4=Print Comments and Box
Default Value: 1
|
| 16 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
Default Value: 0
Prompt Table:
EMPLMT_SRCH_GBL
|