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 PA82.1 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
UPDATED BY
PA170 PA171 PA172 PA371 PA570 PA70.1
PA71.1 PA72.1 PA73.1 HR00.1 HR01.1 PA02.1
PA302 PA502
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 11.6 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 11.6 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
Element: Acct Nd The number of decimals assigned to a PA570 PA70.1
particular account as determined by the PA71.1 PA72.1
account currency. PA73.1
PAB-BASE-CURRENCY Alpha 5 PA170 PA172
Element: Base Currency Contains the company base currency. PA570 PA70.1
PA71.1 PA72.1
PA73.1
PAB-BASE-ND Numeric 1 PA170 PA172
Element: Base Nd The number of decimal positions defined PA570 PA70.1
for the company base currency. PA71.1 PA72.1
PA73.1
PAB-BASE-SALARY Signed 11.2 PA170 PA172
Element: Budget 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: Budget Salary 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
PA82.1
PABSET2 COMPANY Subset BN305 HR11.1
POSITION Where (POSITION != Spaces ) HR11.2 HR511
EFFECT-DATE* PA01.1 PA01.2
PROCESS-LEVEL PA01.3 PA02.1
DEPARTMENT PA100 PA102
JOB-CODE 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 Subset BN305 HR11.1
PROCESS-LEVEL Where (POSITION = Spaces ) HR11.2 HR511
DEPARTMENT PA01.1 PA01.2
JOB-CODE PA01.3 PA02.1
EFFECT-DATE* PA100 PA102
POSITION 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 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
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
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
|