| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TRC |
Character(5) |
VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %Date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: TL_TRC_TBL.DESCR
|
| 6 |
TRC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This defines TRC Type of Hours,Amounts ,Units
A=Amount
H=Hours
U=Units
|
| 7 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set
Prompt Table:
UNITS_TBL
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 9 |
SEND_TO_PAYROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Send to Payroll
Y/N Table Edit
Default Value: N
|
| 10 |
MAX_QTY |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Maximum Quantity
|
| 11 |
MIN_QTY |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Minimum Quantity
|
| 12 |
FACTOR_MULT |
Signed Number(11,4) |
DECIMAL(9,4) NOT NULL |
Multiplication Factor
|
| 13 |
FACTOR_RATE_ADJ |
Signed Number(11,4) |
DECIMAL(9,4) NOT NULL |
Rate Adjustment Factor
|
| 14 |
PER_INSTANCE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Quantity per instance
|
| 15 |
PER_INST_OVR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Is per_instance overridable?
Y/N Table Edit
Default Value: Y
|
| 16 |
RATE |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Rate
|
| 17 |
RATE_OVR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Is rate overridable?
Y/N Table Edit
Default Value: Y
|
| 18 |
ADD_GROSS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribute Costs
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 19 |
DILUTE_LBDST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Used In Labor Dilution
Y/N Table Edit
Default Value: N
|
| 20 |
HRS_REPRESENT_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Hours Represent
A=Actual Hours
C=Compensation Only Hours
Default Value: A
|
| 21 |
SEND_TO_TCD |
Character(1) |
VARCHAR2(1) NOT NULL |
Send To TCD
Y/N Table Edit
Default Value: N
|
| 22 |
COMP_LEAV_IND |
Character(4) |
VARCHAR2(4) NOT NULL |
Comp Leave Indiactor indicates whether a TRC has any effect on Leave and Compensatory time Off
CERN=Comp Time Earned
CTKN=Comp Time Taken
LTKN=Leave Taken
NO=No Comp Time Effect
RULE=Avoid Replacing by Rules
Default Value: NO
|
| 23 |
USED_COPY_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy From Payroll
A=Altered from Payroll Copy
C=Copied from Payroll (Synced)
N=Not from Payroll
Default Value: N
|
| 24 |
TL_COPY_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
This field is used on TRC page to copy the TRC characteristics from Earnings table
Prompt Table:
EARNINGS_TBL
Set Control Field: ERNCD
|
| 25 |
GP_ABSENCE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
GP Absence Flag
Y/N Table Edit
Default Value: N
|
| 26 |
SYNCID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
|
| 27 |
TRC_SUM_CATEGORY |
Character(6) |
VARCHAR2(6) NOT NULL |
TRC Category
Prompt Table:
TL_TRC_CAT_TBL
|
| 28 |
TRC_PUB_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish to Projects
Y/N Table Edit
Default Value: Y
|
| 29 |
TRC_FILTER |
Character(1) |
VARCHAR2(1) NOT NULL |
TRC for Rules Only
Y/N Table Edit
Default Value: N
|
| 30 |
TL_APPR_PAY_ADHOC |
Character(7) |
VARCHAR2(7) NOT NULL |
TL adhoc approval group for payable time
Prompt Table:
TL_APP_GRP_VW
|
| 31 |
TL_APPR_PAY_DEFN |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Payable Time Definition ID
Prompt Table:
TL_AWE_PAY_VW
|
| 32 |
TL_APPR_PAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
TL Approve Payable Time Options
1=Use Workgroup Setting
2=Always
3=Use Rule
Default Value: 1
|
| 33 |
TL_APPR_PAY_GRP1 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL Approval group on the workgroup and TRC page for payable time approvals
Prompt Table:
TL_APP_GRP_VW
|
| 34 |
TL_APPR_PAY_GRP2 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL approval group on the workgroup and trc page for payable time approvals
Prompt Table:
TL_APP_GRP_VW
|
| 35 |
TL_APPR_PAY_PRCS |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Payable Time Process ID
|
| 36 |
TL_APPR_RPT_ADHOC |
Character(7) |
VARCHAR2(7) NOT NULL |
TL adhoc approval group for reported time
Prompt Table:
TL_APP_GRP_VW
|
| 37 |
TL_APPR_RPT_DEFN |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Reported Time Definition ID
Prompt Table:
TL_AWE_RPT_VW
|
| 38 |
TL_APPR_RPT_GRP1 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL Approval Group on the workgroup and TRC page for reported time approvals
Prompt Table:
TL_APP_GRP_VW
|
| 39 |
TL_APPR_RPT_GRP2 |
Character(7) |
VARCHAR2(7) NOT NULL |
TL Approval Group on the workgroup and TRC page for reported time approvals
Prompt Table:
TL_APP_GRP_VW
|
| 40 |
TL_APPR_RPT_PRCS |
Character(30) |
VARCHAR2(30) NOT NULL |
T&L Reported Time Process ID
|
| 41 |
TL_APRV_RPT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Approve Reported Time
Y/N Table Edit
Default Value: N
|
| 42 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 43 |
COMMENTS |
Long Character |
CLOB |
Comment
|