|
|
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 Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
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: Sequence NumbeThe time sequence field insures the
record is unique. It is incremented
automatically.
PPT-PAY-CODE Alpha 4 HS35.1 HS36.1
Element: Payment 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: Account CategoAccount 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: Accounting UniThe 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: Subaccount This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
PPT-PROCESS-LEVEL Alpha 5 HS35.1 HS36.1
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
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: Grade Contains the Pay Grade if used.
PPT-PAY-STEP Numeric 2 HS35.1 HS36.1
Element: Step Contains the Pay Step if used.
PPT-ATTEND-CODE Alpha 2 HS35.1 HS36.1
Element: Attendance CodA 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.
PPT-USER-ID Alpha 10 (Lower Case) HS35.1
Element: User Contains the user ID of the person who
last changed this record.
PPT-PROXY-ID Alpha 10 (Lower Case) HS35.1
Element: Proxy Id
PPT-COMMENT Alpha 40 (Lower Case) HS35.1 HS36.1
Element: Comment Line 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
Account Currency Represents the number of decimals
Code defined for the currency of the object.
PPT-LOCAT-CODE Alpha 10
Element: Location
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 This field contains the reason code,
which indicates the cause for credit
memos.
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
PPTSET2 COMPANY KeyChange
EMPLOYEE
PAY-CODE
TIME-SEQ
PPTSET3 COMPANY KeyChange
EMPLOYEE
ACTIVITY
TIME-SEQ
PPTSET4 COMPANY HS04.1 HS35.1
EMPLOYEE HS36.1 HS535
DATE
TIME-SEQ
PPTSET5 COMPANY KeyChange
EMPLOYEE
STATUS
TIME-SEQ
PPTSET6 COMPANY HS35.1 HS36.1
EMPLOYEE
TIME-SEQ*
PPTSET7 COMPANY
EMPLOYEE
HISTORY
DATE
TIME-SEQ
PRPENDTIME FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY Required
PPT-ACTIVITY -> ACV-ACTIVITY (ACVSET1)
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
|
