|
PRPENDTIME FILE
The Pending Time Record file contains time records that have been input
through the Web Time Entry process.
REFERENCED BY
HS34.1 PR20.4
UPDATED BY
HS04.1 HS35.1 HS36.1 HS535 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPT-COMPANY Numeric 4 HS35.1 HS36.1
Element: Company Hr
PPT-EMPLOYEE Numeric 9 HS35.1 HS36.1
Element: Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PPT-TIME-SEQ Numeric 12 HS35.1 HS36.1
Element: Time Seq The time sequence field insures the
record is unique. It is incremented
automatically.
PPT-PAY-CODE Alpha 4 HS35.1 HS36.1
Element: Pay Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
PPT-HOURS Signed 7.2 HS04.1 HS35.1
Element: Hours Contains the hours. HS36.1
PPT-DATE Numeric 8 (yyyymmdd) HS35.1 HS36.1
Element: Date This field contains the time record
date.
PPT-RATE Signed 13.4 HS35.1 HS36.1
Element: Rate Contains the pay rate.
PPT-JOB-CODE Alpha 9 HS35.1 HS36.1
Element: Job Code Contains a user-defined code that
represents a type of job.
PPT-POSITION Alpha 12 HS35.1 HS36.1
Element: Position Contains the user-defined code that
represents a position in the company.
PPT-SHIFT Numeric 1 HS35.1 HS36.1
Element: Shift Contains the shift number associated
with the pay.
PPT-ACTIVITY Alpha 15 HS35.1 HS36.1
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
PPT-ACCT-CATEGORY Alpha 5 HS35.1 HS36.1
Element: Acct Category Account categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
PPT-GL-COMPANY Numeric 4 HS35.1 HS36.1
Element: Company This field represents the General
Ledger Company this time record is
associated with.
PPT-ACCT-UNIT Alpha 15 HS35.1 HS36.1
Element: Acct Unit The accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
PPT-ACCOUNT Numeric 6 HS35.1 HS36.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
PPT-SUB-ACCOUNT Numeric 4 HS35.1 HS36.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
PPT-PROCESS-LEVEL Alpha 5 HS35.1 HS36.1
Element: Process Lev Hr
PPT-DEPARTMENT Alpha 5 HS35.1 HS36.1
Element: Department Contains the department.
PPT-SCHEDULE Alpha 9 HS35.1 HS36.1
Element: Schedule Contains the pay schedule if used.
PPT-PAY-GRADE Alpha 3 HS35.1 HS36.1
Element: Pay Grade Contains the Pay Grade if used.
PPT-PAY-STEP Numeric 2 HS35.1 HS36.1
Element: Pay Step Contains the Pay Step if used.
PPT-ATTEND-CODE Alpha 2 HS35.1 HS36.1
Element: Attend Code A user-defined alphanumeric code that
represents a reason for an employee's
absence or hours worked. Examples of
attendance codes are, sick, vacation,
overtime, on the job injury, snow day,
tardy, left early, and so on. Validated
in the Attendance Code file.
PPT-OCCURRENCE Alpha 1 HS35.1 HS36.1
Element: Occurrence Contains the attendance occurrence if
used.
PPT-STATUS Numeric 1 HS04.1 HS35.1
Element: Status This field displays the status of the HS36.1 HS535
transaction.
0 = Entered
1 = Submitted
2 = Approved
3 = On Hold
4 = Rejected
5 = Entered; historical
6 = Submitted; historical
7 = Approved; historical
8 = On Hold; historical
9 = Rejected; historical
PPT-USER-ID Alpha 10 (Lower Case) HS04.1 HS35.1
Element: User HS36.1 HS535
PPT-PROXY-ID Alpha 10 (Lower Case) HS35.1
Element: Proxy Id
PPT-COMMENT Alpha 40 (Lower Case) HS35.1 HS36.1
Element: Comment This field contains the comment
narrative.
PPT-MANAGER-ID Alpha 10 (Lower Case) HS35.1 HS36.1
Element: Manager Id Contains the Id of the manager who
approved the record.
PPT-HISTORY Alpha 1 HS35.1 HS36.1
Element: History Y = Yes
N = No
PPT-USERFIELD1 Alpha 10 HS35.1 HS36.1
Element: Userfield1 Contains users specified information.
PPT-USERFIELD2 Alpha 10 HS35.1 HS36.1
Element: Userfield2 Contains user specified information.
PPT-TIMECARD-TYPE Numeric 1 HS04.1 HS35.1
Element: Timecard Type Contains the time card type. Valid HS36.1
values are:
0 = Normal.
1 = Exception.
2
PPT-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PPT-CURR-ND Numeric 1
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
PPT-LOCAT-CODE Alpha 10
Element: Locat Code
PPT-ABN-OBJ-ID Numeric 12
Element: Abn Obj Id This element is not used.
PPT-PAY-UNITS Signed 7.2
Element: Pay Units
PPT-UNIT-MEASURE Alpha 12
Element: Unit Measure
PPT-REASON-CODE Alpha 4
Element: Ta Reason Cd
PPT-DATE-STAMP Numeric 8 (yyyymmdd) HS04.1 HS36.1
Element: Date Stamp This field contains the server date HS535
(month, date, and year) of the last
change to this record.
PPT-TIME-STAMP Numeric 6 (hhmmss) HS04.1 HS36.1
Element: Time Stamp Contains the server time (hour, minute, HS535
and second) when the record was last
changed.
PPT-CREATE-DATE Numeric 8 (yyyymmdd) HS36.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
PPT-CREATE-TIME Numeric 6 (hhmmss) HS36.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
PPT-CREATE-USER-ID Alpha 10 (Lower Case) HS36.1
Element: User Id Contains the user ID of the person who
last changed this record.
PRPENDTIME FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPTSET1 COMPANY HR11.1 PA115
EMPLOYEE HS34.1 HS35.1
TIME-SEQ HS36.1 PR20.4
PPTSET4 COMPANY HS04.1 HS35.1
EMPLOYEE HS36.1 HS535
DATE
TIME-SEQ
PPTSET6 COMPANY HS35.1 HS36.1
EMPLOYEE
TIME-SEQ*
PRPENDTIME FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
PPT-ACTIVITY -> ACV-ACTIVITY
Acuom ACUOM Required
When PPT-UNIT-MEASURE != Spaces
PPT-UNIT-MEASURE -> UOM-UNIT-MEASURE
Deptcode DEPTCODE Required
PPT-COMPANY -> DPT-COMPANY
PPT-PROCESS-LEVEL -> DPT-PROCESS-LEVEL
PPT-DEPARTMENT -> DPT-DEPARTMENT
Employee EMPLOYEE Required
PPT-COMPANY -> EMP-COMPANY
PPT-EMPLOYEE -> EMP-EMPLOYEE
Jobcode JOBCODE Required
PPT-COMPANY -> JBC-COMPANY
PPT-JOB-CODE -> JBC-JOB-CODE
Prsystem PRSYSTEM Required
PPT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Reason Code TAREASCODE Required
When (PPT-REASON-CODE != Spaces )
PPT-COMPANY -> TRE-COMPANY
PPT-REASON-CODE -> TRE-REASON-CODE
|