PABUDGET

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
PA82.1


UPDATED BY
PA170 PA171 PA172 PA371 PA570 PA70.1
PA71.1 PA72.1 PA73.1 HR00.1 HR01.1 PA02.1
PA302 PA406 PA502 BN305 HR11.1 HR11.2
HR511 PA01.1 PA01.2 PA01.3 PA100 PA102
PA11.1 PA115 PA13.1 PA13.2 PA201 PA271
PA272 PA42.1 PA42.3 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA535 PA79.1 PA80.1 PA80.2
PR110 PR113 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAB-COMPANY
Element: Company		Numeric 4
Contains the company number.
PA172 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PAB-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
PA172 PA570
PA70.1 PA72.1
PAB-PROCESS-LEVEL
Element: Process Level		Alpha 5
Contains the process level.
PA171 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
PA171 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-JOB-CODE
Element: Job Code		Alpha 9
Contains a user-defined code that represents a type of job.
PA171 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-EFFECT-DATE
Element: Effective Date		Numeric 8 (yyyymmdd)
Contains the effective date of a budget.
PA171 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
Contains the end date for a budget.
PA170 PA171
PA172 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PAB-CHG-REASON
Element: Reason Code		Alpha 10
Contains the reason a change was made to the budget.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-HDCNT
Element: Head Count		Numeric 5
Contains the budgeted head count.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1 PA80.1
PAB-AUTH-HDCNT
Authorized Head
Count		Numeric 5
Contains the authorized head count if authorized counts are used.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1 PA80.1
PAB-FTE
Element: Full Time Equivalent		Signed 11.6
Contains the budgeted full time equivalent factor.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1 PA80.1
PAB-AUTH-FTE
Element: Authorized FTE		Signed 11.6
Contains the authorized full time equivalent factor if authorized counts are used.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1 PA80.1
PAB-SALARY
Element: Salary		Signed 11.2
Contains the budgeted salary as defined by the user.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-AUTH-SALARY
Element: Authorized Salary		Signed 11.2
Contains the authorized salary as defined by the user.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
Contains the date (month, day, and year) a change was made to the record. Each date is tied to a user ID and time to create a history of changes to the record.
PA170 PA171
PA172 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PAB-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the time (hour, minute, and second) a change was made to the record. Each time stamp is tied to a date and user ID to create a history of changes to the record.
PA170 PA171
PA172 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PAB-USER-ID
Element: User ID		Alpha 10 (Lower Case)
Contains the user ID of a user who has made changes to the record. The user ID is tied to a date and time to create a history of changes to the record.
PA170 PA171
PA172 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PAB-CURRENCY-CODE
Element: Currency Code		Alpha 5
Contains the currency in which the salary is recorded.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-BASE-CURRENCY
Element: Base Currency		Alpha 5
Contains the company base currency.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-BASE-ND
Element: Base Nd		Numeric 1
The number of decimal positions defined for the company base currency.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-BASE-SALARY
Element: Budget Salary		Signed 11.2
Contains the budgeted salary in the company's base currency.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-BASE-AUTH-SAL
Element: Budget Salary		Signed 11.2
Contains the authorized salary in the company's base currency.
PA170 PA172
PA570 PA70.1
PA71.1 PA72.1
PA73.1


PABUDGET FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PABSET1 COMPANY
POSITION
PROCESS-LEVEL
DEPARTMENT
JOB-CODE
EFFECT-DATE
HR00.1 HR01.1
PA02.1 PA172
PA302 PA406
PA502 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PA82.1
PABSET2 COMPANY
POSITION
EFFECT-DATE*
PROCESS-LEVEL
DEPARTMENT
JOB-CODE
Subset
Where(POSITION !=Spaces)
...
BN305 HR11.1
HR11.2 HR511
PA01.1 PA01.2
PA01.3 PA02.1
PA100 PA102
PA11.1 PA115
PA13.1 PA13.2
PA170 PA172
PA201 PA271
PA272 PA371
PA42.1 PA42.3
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PA535 PA570
PABSET3 COMPANY
PROCESS-LEVEL
DEPARTMENT
JOB-CODE
EFFECT-DATE*
POSITION
Subset
Where(POSITION =Spaces)
...
BN305 HR11.1
HR11.2 HR511
PA01.1 PA01.2
PA01.3 PA02.1
PA100 PA102
PA11.1 PA115
PA13.1 PA13.2
PA170 PA171
PA172 PA201
PA271 PA272
PA371 PA42.1
PA42.3 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PA535


PABUDGET FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Paencumber PAENCUMBER
PAB-COMPANY->PEN-COMPANY
PAB-POSITION->PEN-POSITION
PAB-PROCESS-LEVEL->PEN-PROCESS-LEVEL
PAB-DEPARTMENT->PEN-DEPARTMENT
PAB-JOB-CODE->PEN-JOB-CODE
  PEN-EMPLOYEE
  PEN-GLT-OBJ-ID
  PEN-ATN-OBJ-ID
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

File created: Wed Jun 08 20:50:22 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.