PABUDGET FILE
Budget
The Personnel Administration Budget file contains the budgeted head count,
FTE, or both. These budgeted counts are determined at one or more points
during the fiscal period. The budget file holds effective dated records. Both
historical and future records are maintained here.
REFERENCED BY
PA406 HR11.1 HR511 PA01.1 PA01.2 PA01.3
PA100 PA102 PA11.1 PA13.1 PA13.2 PA201
PA271 PA272 PA42.1 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PA79.1 PA80.1 PA80.2
PR13.1
UPDATED BY
HR700 PA170 PA171 PA172 PA371 PA570
PA70.1 PA71.1 PA72.1 PA73.1 HR00.1 HR01.1
PA02.1 PA302 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAB-COMPANY Numeric 4 PA172 PA570
Company Contains the company number. PA70.1 PA71.1
PA72.1 PA73.1
PAB-POSITION Alpha 12 PA172 PA570
Position Contains the user-defined code that PA70.1 PA72.1
represents a position in the company.
PAB-PROCESS-LEVEL Alpha 5 PA171 PA172
Process Level Contains the process level. PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-DEPARTMENT Alpha 5 PA171 PA172
Department Contains the department. PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-JOB-CODE Alpha 9 PA171 PA172
Job Code Contains a user-defined code that PA570 PA70.1
represents a type of job. PA71.1 PA72.1
PA73.1
PAB-EFFECT-DATE Numeric 8 (yyyymmdd) PA171 PA172
Effective Date Contains the effective date of a PA570 PA70.1
budget. PA71.1 PA72.1
PA73.1
PAB-END-DATE Numeric 8 (yyyymmdd) PA170 PA171
End Date Contains the end date for a budget. PA172 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PAB-CHG-REASON Alpha 10 PA170 PA172
Reason Code Contains the reason a change was made PA570 PA70.1
to the budget. PA71.1 PA72.1
PA73.1
PAB-HDCNT Numeric 5 PA170 PA172
Head Count Contains the budgeted head count. PA570 PA70.1
PA71.1 PA72.1
PA73.1 PA80.1
PAB-AUTH-HDCNT Numeric 5 PA170 PA172
Authorized Head Contains the authorized head count if PA570 PA70.1
Count authorized counts are used. PA71.1 PA72.1
PA73.1 PA80.1
PAB-FTE Signed 8.3 PA170 PA172
Full Time Equivalent Contains the budgeted full time PA570 PA70.1
equivalent factor. PA71.1 PA72.1
PA73.1 PA80.1
PAB-AUTH-FTE Signed 8.3 PA170 PA172
Authorized FTE Contains the authorized full time PA570 PA70.1
equivalent factor if authorized counts PA71.1 PA72.1
are used. PA73.1 PA80.1
PAB-SALARY Signed 11.2 PA170 PA172
Salary Contains the budgeted salary as defined PA570 PA70.1
by the user. PA71.1 PA72.1
PA73.1
PAB-AUTH-SALARY Signed 11.2 PA170 PA172
Authorized Salary Contains the authorized salary as PA570 PA70.1
defined by the user. PA71.1 PA72.1
PA73.1
PAB-DATE-STAMP Numeric 8 (yyyymmdd) PA170 PA171
Date Stamp Contains the date (month, day, and PA172 PA570
year) a change was made to the record. PA70.1 PA71.1
Each date is tied to a user ID and time PA72.1 PA73.1
to create a history of changes to the
record.
PAB-TIME-STAMP Numeric 6 (hhmmss) PA170 PA171
Time Stamp Contains the time (hour, minute, and PA172 PA570
second) a change was made to the record. PA70.1 PA71.1
Each time stamp is tied to a date and PA72.1 PA73.1
user ID to create a history of changes
to the record.
PAB-USER-ID Alpha 10 (Lower Case) PA170 PA171
User ID Contains the user ID of a user who has PA172 PA570
made changes to the record. The user ID PA70.1 PA71.1
is tied to a date and time to create a PA72.1 PA73.1
history of changes to the record.
PAB-CURRENCY-CODE Alpha 5 HR700 PA170
Currency Code Contains the currency in which the PA172 PA570
salary is recorded. PA70.1 PA71.1
PA72.1 PA73.1
PAB-CURR-ND Numeric 1 HR700 PA170
Currency Number of Represents the number of decimals PA172 PA570
Decimals defined for the currency of the object. PA70.1 PA71.1
PA72.1 PA73.1
PAB-BASE-CURRENCY Alpha 5 HR700 PA170
Base Currency Contains the company base currency. PA172 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PAB-BASE-ND Numeric 1 HR700 PA170
Base Number Of The number of decimal positions defined PA172 PA570
Decimals for the company base currency. PA70.1 PA71.1
PA72.1 PA73.1
PAB-BASE-SALARY Signed 11.2 HR700 PA170
Base Salary Contains the budgeted salary in the PA172 PA570
company's base currency. PA70.1 PA71.1
PA72.1 PA73.1
PAB-BASE-AUTH-SAL Signed 11.2 HR700 PA170
Base Auth Sal Contains the authorized salary in the PA172 PA570
company's base currency. PA70.1 PA71.1
PA72.1 PA73.1
PABUDGET FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PABSET1 COMPANY HR00.1 HR01.1
POSITION HR700 PA02.1
PROCESS-LEVEL PA172 PA302
DEPARTMENT PA406 PA570
JOB-CODE PA70.1 PA71.1
EFFECT-DATE PA72.1 PA73.1
PBIP.1
PABSET2 COMPANY Subset HR11.1 HR511
POSITION Where (POSITION != Spaces ) PA01.1 PA01.2
EFFECT-DATE* PA01.3 PA02.1
PROCESS-LEVEL PA100 PA102
DEPARTMENT PA11.1 PA13.1
JOB-CODE PA13.2 PA170
PA172 PA201
PA271 PA272
PA371 PA42.1
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA570 PA70.1
PA71.1 PA72.1
PA73.1 PA79.1
...
PABSET3 COMPANY Subset HR11.1 HR511
PROCESS-LEVEL Where (POSITION = Spaces ) PA01.1 PA01.2
DEPARTMENT PA01.3 PA02.1
JOB-CODE PA100 PA102
EFFECT-DATE* PA11.1 PA13.1
POSITION PA13.2 PA170
PA171 PA172
PA201 PA271
PA272 PA371
PA42.1 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA570
PA70.1 PA71.1
PA72.1 PA73.1
...
PABUDGET FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
When PAB-CURRENCY-CODE != Spaces
PAB-BASE-CURRENCY -> CUC-CURRENCY-CODE
Chg Reason PCODES Required
When (PAB-CHG-REASON != Spaces )
"BD" -> PCO-TYPE
PAB-CHG-REASON -> PCO-CODE
Company PRSYSTEM Required
When (PAB-PROCESS-LEVEL = Spaces )
PAB-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When PAB-CURRENCY-CODE != Spaces
PAB-CURRENCY-CODE -> CUC-CURRENCY-CODE
Department DEPTCODE Required
When (PAB-DEPARTMENT != Spaces )
PAB-COMPANY -> DPT-COMPANY
PAB-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
PAB-DEPARTMENT -> DPT-DEPARTMENT
Job Code JOBCODE Required
When (PAB-JOB-CODE != Spaces )
PAB-COMPANY -> JBC-COMPANY
PAB-JOB-CODE -> JBC-JOB-CODE
Process Level PRSYSTEM Required
When (PAB-PROCESS-LEVEL != Spaces )
PAB-COMPANY -> PRS-COMPANY
PAB-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
PABUDGET FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Pos Rules PAPOSRULE
Valid When (PAB-JOB-CODE != Spaces )
PAB-COMPANY -> PPR-COMPANY
PAB-PROCESS-LEVEL -> PPR-PROCESS-LEVEL
PAB-DEPARTMENT -> PPR-DEPARTMENT
PPR-EFFECT-DATE
Position PAPOSITION Required
When (PAB-POSITION != Spaces )
PAB-COMPANY -> POS-COMPANY
PAB-POSITION -> POS-POSITION
POS-EFFECT-DATE
Req Job PAJOBREQ
Valid When (PAB-JOB-CODE != Spaces )
PAB-COMPANY -> PJR-COMPANY
PAB-PROCESS-LEVEL -> PJR-PROCESS-LEVEL
PAB-DEPARTMENT -> PJR-DEPARTMENT
PAB-JOB-CODE -> PJR-JOB-CODE
PJR-REQUISITION
Req Pos PAJOBREQ
Valid When (PAB-POSITION != Spaces )
PAB-COMPANY -> PJR-COMPANY
PAB-POSITION -> PJR-POSITION
PJR-REQUISITION
|