Lawson Insight Technical Documentation |
|
PABUDGET
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 HR11.2 HR511 HR650 PA01.1
PA01.2 PA01.3 PA100 PA102 PA11.1 PA13.1
PA13.2 PA201 PA271 PA272 PA42.1 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA79.1 PA80.1
PA80.2 PR110 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8
UPDATED BY
PA170 PA171 PA172 PA371 PA570 PA70.1
PA71.1 PA72.1 PA73.1 HR00.1 HR01.1 PA02.1
PA302 PA502 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PAB-COMPANY Numeric 4 PA172 PA570
Element: Company Contains the company number. PA70.1 PA71.1
PA72.1 PA73.1
PAB-POSITION Alpha 12 PA172 PA570
Element: Position Contains the user-defined code that PA70.1 PA72.1
represents a position in the company.
PAB-PROCESS-LEVEL Alpha 5 PA171 PA172
Element: Process Level Contains the process level. PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-DEPARTMENT Alpha 5 PA171 PA172
Element: Department Contains the department. PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-JOB-CODE Alpha 9 PA171 PA172
Element: 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
Element: Effective DateContains the effective date of a PA570 PA70.1
budget. PA71.1 PA72.1
PA73.1
PAB-END-DATE Numeric 8 (yyyymmdd) PA170 PA171
Element: 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
Element: 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
Element: 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
Element: Full Time EquiContains 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
Element: Authorized FTEContains 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
Element: 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
Element: Authorized SalContains 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
Element: 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
Element: 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
Element: 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 PA170 PA172
Element: Currency Code Contains the currency in which the PA570 PA70.1
salary is recorded. PA71.1 PA72.1
PA73.1
PAB-CURR-ND Numeric 1 PA170 PA172
Account Currency PA570 PA70.1
Code PA71.1 PA72.1
PA73.1
PAB-BASE-CURRENCY Alpha 5 PA170 PA172
To Company Base Contains the company base currency. PA570 PA70.1
Currency PA71.1 PA72.1
PA73.1
PAB-BASE-ND Numeric 1 PA170 PA172
Account Currency PA570 PA70.1
Code PA71.1 PA72.1
PA73.1
PAB-BASE-SALARY Signed 11.2 PA170 PA172
Element: Base Salary Contains the budgeted salary in the PA570 PA70.1
company's base currency. PA71.1 PA72.1
PA73.1
PAB-BASE-AUTH-SAL Signed 11.2 PA170 PA172
Element: Base Auth Sal Contains the authorized salary in the PA570 PA70.1
company's base currency. PA71.1 PA72.1
PA73.1
PABUDGET FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PABSET1 COMPANY HR00.1 HR01.1
POSITION PA02.1 PA172
PROCESS-LEVEL PA302 PA406
DEPARTMENT PA502 PA570
JOB-CODE PA70.1 PA71.1
EFFECT-DATE PA72.1 PA73.1
PBIP.1 PR197
PABSET2 COMPANY Subset HR11.1 HR11.2
POSITION Where (POSITION != Spaces ) HR511 HR650
EFFECT-DATE* PA01.1 PA01.2
PROCESS-LEVEL PA01.3 PA02.1
DEPARTMENT PA100 PA102
JOB-CODE PA11.1 PA13.1
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
...
PABSET3 COMPANY Subset HR11.1 HR11.2
PROCESS-LEVEL Where (POSITION = Spaces ) HR511 HR650
DEPARTMENT PA01.1 PA01.2
JOB-CODE PA01.3 PA02.1
EFFECT-DATE* PA100 PA102
POSITION PA11.1 PA13.1
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
...
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
|