PRPENDTIME

The Pending Time Record file contains time records that have been input through the Web Time Entry process.
UPDATED BY
HS04.1 HS35.1 HS36.1 HS535 HS536 HR11.1
PA115 HS34.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PPT-COMPANY
Element: Company Hr
Numeric 4
HS35.1 HS36.1
PPT-EMPLOYEE
Element: Employee
Numeric 9
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.
HS35.1 HS36.1
PPT-TIME-SEQ
Element: Time Seq
Numeric 12
The time sequence field insures the record is unique. It is incremented automatically.
HS35.1 HS36.1
PPT-PAY-CODE
Element: Pay Code
Alpha 4
Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
HS35.1 HS36.1
PPT-HOURS
Element: Hours
Signed 7.2
Contains the hours.
HS04.1 HS35.1
HS36.1
PPT-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the time record date.
HS35.1 HS36.1
PPT-RATE
Element: Rate
Signed 13.4
Contains the pay rate.
HS35.1 HS36.1
PPT-JOB-CODE
Element: Job Code
Alpha 9
Contains a user-defined code that represents a type of job.
HS35.1 HS36.1
PPT-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
HS35.1 HS36.1
PPT-SHIFT
Element: Shift
Numeric 1
Contains the shift number associated with the pay.
HS35.1 HS36.1
PPT-ACTIVITY
Element: Activity
Alpha 15
Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.
HS35.1 HS36.1
PPT-ACCT-CATEGORY
Element: Acct Category
Alpha 5
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
HS35.1 HS36.1
PPT-GL-COMPANY
Element: Company
Numeric 4
This field represents the General Ledger Company this time record is associated with.
HS35.1 HS36.1
PPT-ACCT-UNIT
Element: Acct Unit
Alpha 15
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.
HS35.1 HS36.1
PPT-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
HS35.1 HS36.1
PPT-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
HS35.1 HS36.1
PPT-PROCESS-LEVEL
Element: Process Lev Hr
Alpha 5
HS35.1 HS36.1
PPT-DEPARTMENT
Element: Department
Alpha 5
Contains the department.
HS35.1 HS36.1
PPT-SCHEDULE
Element: Schedule
Alpha 9
Contains the pay schedule if used.
HS35.1 HS36.1
PPT-PAY-GRADE
Element: Pay Grade
Alpha 3
Contains the Pay Grade if used.
HS35.1 HS36.1
PPT-PAY-STEP
Element: Pay Step
Numeric 2
Contains the Pay Step if used.
HS35.1 HS36.1
PPT-ATTEND-CODE
Element: Attend Code
Alpha 2
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.
HS35.1 HS36.1
PPT-OCCURRENCE
Element: Occurrence
Alpha 1
Contains the attendance occurrence if used.
HS35.1 HS36.1
PPT-STATUS
Element: Status
Numeric 1
This field displays the status of the 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
HS04.1 HS35.1
HS36.1 HS535
PPT-USER-ID
Element: User
Alpha 10 (Lower Case)
HS04.1 HS35.1
HS36.1 HS535
PPT-PROXY-ID
Element: Proxy Id
Alpha 10 (Lower Case)
HS35.1
PPT-COMMENT
Element: Comment
Alpha 40 (Lower Case)
This field contains the comment narrative.
HS35.1 HS36.1
PPT-MANAGER-ID
Element: Manager Id
Alpha 10 (Lower Case)
Contains the Id of the manager who approved the record.
HS35.1 HS36.1
PPT-HISTORY
Element: History
Alpha 1

Y = Yes
N = No
HS35.1 HS36.1
PPT-USERFIELD1
Element: Userfield1
Alpha 10
Contains users specified information.
HS35.1 HS36.1
PPT-USERFIELD2
Element: Userfield2
Alpha 10
Contains user specified information.
HS35.1 HS36.1
PPT-TIMECARD-TYPE
Element: Timecard Type
Numeric 1
Contains the time card type. Valid values are: 0 = Normal. 1 = Exception.
2
HS04.1 HS35.1
HS36.1
PPT-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PPT-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PPT-LOCAT-CODE
Element: Locat Code
Alpha 10
PPT-ABN-OBJ-ID
Element: Abn Obj Id
Numeric 12
This element is not used.
PPT-PAY-UNITS
Element: Pay Units
Signed 7.2
PPT-UNIT-MEASURE
Element: Unit Measure
Alpha 12
PPT-REASON-CODE
Element: Ta Reason Cd
Alpha 4
PPT-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
HS04.1 HS36.1
HS535
PPT-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HS04.1 HS36.1
HS535
PPT-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
HS36.1
PPT-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HS36.1
PPT-CREATE-USER-ID
Element: User Id
Alpha 10 (Lower Case)
Contains the user ID of the person who last changed this record.
HS36.1


PRPENDTIME FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PPTSET1 COMPANY
EMPLOYEE
TIME-SEQ
HR11.1 PA115
HS34.1 HS35.1
HS36.1
PPTSET4 COMPANY
EMPLOYEE
DATE
TIME-SEQ
HS04.1 HS35.1
HS36.1 HS535
HS536
PPTSET6 COMPANY
EMPLOYEE
TIME-SEQ*
HS35.1 HS36.1


PRPENDTIME FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:51:12 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.