Pending Time Record
The Pending Time Record file contains time records that have been input through the Web Time Entry process.
REFERENCED BY
HS34.1 |
HS19.2 | HS04.1 | HS35.1 | HS36.1 | HS535 | HS536 |
HR11.1 | PA115 | PR20.4 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
---|---|---|---|---|---|---|
PPT-COMPANY Element: Company Hr | Numeric 4 |
|
||||
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. |
|
||||
PPT-TIME-SEQ Element: Time Seq | Numeric 12 The time sequence field insures the record is unique. It is incremented automatically. |
|
||||
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. |
|
||||
PPT-HOURS Element: Hours | Signed 7.2 Contains the hours. |
|
||||
PPT-DATE Element: Date | Numeric 8 (yyyymmdd) This field contains the time record date. |
|
||||
PPT-RATE Element: Rate | Signed 13.4 Contains the pay rate. |
|
||||
PPT-JOB-CODE Element: Job Code | Alpha 9 Contains a user-defined code that represents a type of job. |
|
||||
PPT-POSITION Element: Position | Alpha 12 Contains the user-defined code that represents a position in the company. |
|
||||
PPT-SHIFT Element: Shift | Numeric 1 Contains the shift number associated with the pay. |
|
||||
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. |
|
||||
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 |
|
||||
PPT-GL-COMPANY Element: Company | Numeric 4 This field represents the General Ledger Company this time record is associated with. |
|
||||
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. |
|
||||
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. |
|
||||
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. |
|
||||
PPT-PROCESS-LEVEL Element: Process Lev Hr | Alpha 5 |
|
||||
PPT-DEPARTMENT Element: Department | Alpha 5 Contains the department. |
|
||||
PPT-SCHEDULE Element: Schedule | Alpha 9 Contains the pay schedule if used. |
|
||||
PPT-PAY-GRADE Element: Pay Grade | Alpha 3 Contains the Pay Grade if used. |
|
||||
PPT-PAY-STEP Element: Pay Step | Numeric 2 Contains the Pay Step if used. |
|
||||
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. |
|
||||
PPT-OCCURRENCE Element: Occurrence | Alpha 1 Contains the attendance occurrence if used. |
|
||||
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 |
|
||||
PPT-USER-ID Element: User | Alpha 10 (Lower Case) |
|
||||
PPT-PROXY-ID Element: Proxy Id | Alpha 10 (Lower Case) |
|
||||
PPT-COMMENT Element: Comment | Alpha 40 (Lower Case) This field contains the comment narrative. |
|
||||
PPT-MANAGER-ID Element: Manager Id | Alpha 10 (Lower Case) Contains the Id of the manager who approved the record. |
|
||||
PPT-HISTORY Element: History | Alpha 1 Y = Yes N = No |
|
||||
PPT-USERFIELD1 Element: Userfield1 | Alpha 10 Contains users specified information. |
|
||||
PPT-USERFIELD2 Element: Userfield2 | Alpha 10 Contains user specified information. |
|
||||
PPT-TIMECARD-TYPE Element: Timecard Type | Numeric 1 Contains the time card type. Valid values are: 0 = Normal. 1 = Exception. 2 |
|
||||
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. |
|
||||
PPT-TIME-STAMP Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||
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. |
|
||||
PPT-CREATE-TIME Element: Time Stamp | Numeric 6 (hhmmss) Contains the server time (hour, minute, and second) when the record was last changed. |
|
||||
PPT-CREATE-USER-ID Element: User Id | Alpha 10 (Lower Case) Contains the user ID of the person who last changed this record. |
|
||||
PPT-MEMO Element: Text Comment | Alpha 64 (Lower Case) |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PPTSET1 |
COMPANY EMPLOYEE TIME-SEQ |
|
| ||||||||||||||
PPTSET4 |
COMPANY EMPLOYEE DATE TIME-SEQ |
|
| ||||||||||||||
PPTSET6 |
COMPANY EMPLOYEE TIME-SEQ* |
|
| ||||||||||||||
PPTSET7 |
COMPANY ABN-OBJ-ID EMPLOYEE TIME-SEQ |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acactivity | ACACTIVITY |
Required
| ||||||||||||
Acuom | ACUOM |
Required
| ||||||||||||
Deptcode | DEPTCODE |
Required
| ||||||||||||
Employee | EMPLOYEE |
Required
| ||||||||||||
Jobcode | JOBCODE |
Required
| ||||||||||||
Prsystem | PRSYSTEM |
Required
| ||||||||||||
Reason Code | TAREASCODE |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.