 |
Lawson Insight Technical Documentation |
|
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 HR511 HR650 PA01.1 PA01.2 PA01.3
PA11.1 PA201 PA271 PA272 PA42.1 PA513
PA79.1 PA80.1 PA80.2 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 PA302
PA502 PR197
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 PA170 PA172
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
Currency Number of Represents the number of decimals PA570 PA70.1
Decimals defined for the currency of the object. PA71.1 PA72.1
PA73.1
PAB-BASE-CURRENCY Alpha 5 PA170 PA172
Base Currency Contains the company base currency. PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-BASE-ND Numeric 1 PA170 PA172
Base Number Of The number of decimal positions defined PA570 PA70.1
Decimals for the company base currency. PA71.1 PA72.1
PA73.1
PAB-BASE-SALARY Signed 11.2 PA170 PA172
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
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 PA172 PA302
PROCESS-LEVEL PA406 PA502
DEPARTMENT PA570 PA70.1
JOB-CODE PA71.1 PA72.1
EFFECT-DATE PA73.1 PR197
PABSET2 COMPANY Subset HR511 HR650
POSITION Where (POSITION != Spaces ) PA01.1 PA01.2
EFFECT-DATE* PA01.3 PA11.1
PROCESS-LEVEL PA170 PA172
DEPARTMENT PA201 PA271
JOB-CODE PA272 PA371
PA42.1 PA502
PA513 PA570
PA70.1 PA71.1
PA72.1 PA73.1
PA79.1 PA80.1
PA80.2 PR13.1
PR13.5 PR13.6
PR13.8
PABSET3 COMPANY Subset HR511 HR650
PROCESS-LEVEL Where (POSITION = Spaces ) PA01.1 PA01.2
DEPARTMENT PA01.3 PA11.1
JOB-CODE PA170 PA171
EFFECT-DATE* PA172 PA201
POSITION PA271 PA272
PA371 PA42.1
PA502 PA513
PA570 PA70.1
PA71.1 PA72.1
PA73.1 PA79.1
PA80.1 PA80.2
PR13.1 PR13.5
PR13.6 PR13.8
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
|