INTFC_PROJ_ACT (SQL Table)	Index Back
Project Time & Labor Interface Interfact table used for Project <-> T&L integration. Holds the actual payable time as subscribed from T&L.

INTFC_PROJ_ACT

(SQL Table)

Project Time & Labor Interface

Interfact table used for Project <-> T&L integration. Holds the actual payable time as subscribed from T&L.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PROJ_TEAM_VW

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 DUR Date(10) DATE Date Under Report

4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

5 TASK_PRFL_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL TASK PROFILE TEMPLATE ID

6 SHIFT_ID Character(10) VARCHAR2(10) NOT NULL Shift ID

7 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
Prompt Table: TL_TM_RPTCD_VW

8 TL_QUANTITY Signed Number(20,6) DECIMAL(18,6) NOT NULL Quantity

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

11 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: CO_STATETAX_TBL

12 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
Prompt Table: CO_LOCALTAX_TBL

13 COMP_RATECD Character(6) VARCHAR2(6) NOT NULL Comp Rate Code
Prompt Table: COMP_RT_REG_VW

14 BILLABLE_IND Character(1) VARCHAR2(1) NOT NULL Billable Indicator

15 OVERRIDE_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Override Rate

16 EST_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Estimated Gross

17 LBR_DIST_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Labor Distribution Amount

18 DILUTED_GROSS Signed Number(20,6) DECIMAL(18,6) NOT NULL Diluted Labor Distribution Amt

19 CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

20 PAYABLE_STATUS Character(2) VARCHAR2(2) NOT NULL Payable Status

21 PAY_SYSTEM Character(4) VARCHAR2(4) NOT NULL Pay System

22 PAYROLL_REQ_NUM Number(6,0) INTEGER NOT NULL Last Payroll Request Number

23 FROZEN_SW Character(1) VARCHAR2(1) NOT NULL Frozen

24 FROZEN_DATE Date(10) DATE Frozen Date

25 RECORD_ONLY_ADJ Character(1) VARCHAR2(1) NOT NULL Record Only Adjustment

26 PUBLISH_SW Character(1) VARCHAR2(1) NOT NULL If Data was published

27 ACTUAL_PUB_DATE Date(10) DATE Publish Date

28 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

29 APPRV_PRCS_DTTM DateTime(26) TIMESTAMP Approval Process Datetime

30 SOURCE_IND Character(1) VARCHAR2(1) NOT NULL Source Indicator

31 ORIG_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Original Sequence Number

32 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

33 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: BUS_UNIT_TBL_HR

34 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

35 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: TL_LOCATION_VW

36 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

37 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code SetID

38 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
Prompt Table: PC_JOBCODE_VW

39 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Prompt Table: POSITION_DATA

40 CUSTOMER Character(10) VARCHAR2(10) NOT NULL Customer
Prompt Table: TL_CUSTOMER

41 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Account Code
Prompt Table: ACCT_CD_TBL

42 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDITTABLE3

43 BUSINESS_UNIT_PF Character(5) VARCHAR2(5) NOT NULL Perf Measurement business unit
Prompt Table: BUS_UNIT_TBL_PF

44 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDITTABLE

45 SETID_ACTIVITY Character(5) VARCHAR2(5) NOT NULL Activity SetID

46 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDITTABLE2

47 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RES_TYPE

48 SETID_RESOURCE Character(5) VARCHAR2(5) NOT NULL Resource SetID

49 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDITTABLE4

50 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDITTABLE5

51 TASK Character(5) VARCHAR2(5) NOT NULL Task
Prompt Table: TL_TASK

52 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
Prompt Table: TL_USER_FIELD_1

53 USER_FIELD_2 Character(10) VARCHAR2(10) NOT NULL User Field 2
Prompt Table: TL_USER_FIELD_2

54 USER_FIELD_3 Character(15) VARCHAR2(15) NOT NULL User Field 3
Prompt Table: TL_USER_FIELD_3

55 USER_FIELD_4 Character(20) VARCHAR2(20) NOT NULL User Field 4
Prompt Table: TL_USER_FIELD_4

56 USER_FIELD_5 Character(20) VARCHAR2(20) NOT NULL User Field 5
Prompt Table: TL_USER_FIELD_5

57 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

58 DEPTID_CA Character(10) VARCHAR2(10) NOT NULL Department

59 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

60 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Default Value: PROJ_ACTIVITY.PROJECT_ID
Prompt Table: %EDIT_DEPT

61 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

62 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

63 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

64 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

65 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

66 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

67 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

68 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

69 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

70 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

71 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

72 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

73 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL TRC Type
A=Amount
H=Hours
U=Units

74 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

75 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

76 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

77 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

78 PC_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL PC Distribution Status
B=Budget Check
D=Distributed
G=Generated
H=Hold
I=Ignore
M=Modified
N=Not Distributed
S=Staged

79 TL_TIME_TO_PAY Character(1) VARCHAR2(1) NOT NULL Send Time to Payroll

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PROJ_TEAM_VW
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	DUR	Date(10)	DATE	Date Under Report
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	TASK_PRFL_TMPLT_ID	Character(10)	VARCHAR2(10) NOT NULL	TASK PROFILE TEMPLATE ID
6	SHIFT_ID	Character(10)	VARCHAR2(10) NOT NULL	Shift ID
7	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code Prompt Table: TL_TM_RPTCD_VW
8	TL_QUANTITY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Quantity
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
10	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
11	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: CO_STATETAX_TBL
12	LOCALITY	Character(10)	VARCHAR2(10) NOT NULL	Locality Prompt Table: CO_LOCALTAX_TBL
13	COMP_RATECD	Character(6)	VARCHAR2(6) NOT NULL	Comp Rate Code Prompt Table: COMP_RT_REG_VW
14	BILLABLE_IND	Character(1)	VARCHAR2(1) NOT NULL	Billable Indicator
15	OVERRIDE_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Override Rate
16	EST_GROSS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Estimated Gross
17	LBR_DIST_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Labor Distribution Amount
18	DILUTED_GROSS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Diluted Labor Distribution Amt
19	CURRENCY_CD2	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
20	PAYABLE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Payable Status
21	PAY_SYSTEM	Character(4)	VARCHAR2(4) NOT NULL	Pay System
22	PAYROLL_REQ_NUM	Number(6,0)	INTEGER NOT NULL	Last Payroll Request Number
23	FROZEN_SW	Character(1)	VARCHAR2(1) NOT NULL	Frozen
24	FROZEN_DATE	Date(10)	DATE	Frozen Date
25	RECORD_ONLY_ADJ	Character(1)	VARCHAR2(1) NOT NULL	Record Only Adjustment
26	PUBLISH_SW	Character(1)	VARCHAR2(1) NOT NULL	If Data was published
27	ACTUAL_PUB_DATE	Date(10)	DATE	Publish Date
28	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
29	APPRV_PRCS_DTTM	DateTime(26)	TIMESTAMP	Approval Process Datetime
30	SOURCE_IND	Character(1)	VARCHAR2(1) NOT NULL	Source Indicator
31	ORIG_SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Original Sequence Number
32	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
33	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: BUS_UNIT_TBL_HR
34	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
35	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: TL_LOCATION_VW
36	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
37	SETID_JOBCODE	Character(5)	VARCHAR2(5) NOT NULL	Job Code SetID
38	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: PC_JOBCODE_VW
39	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Prompt Table: POSITION_DATA
40	CUSTOMER	Character(10)	VARCHAR2(10) NOT NULL	Customer Prompt Table: TL_CUSTOMER
41	ACCT_CD	Character(25)	VARCHAR2(25) NOT NULL	Account Code Prompt Table: ACCT_CD_TBL
42	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: %EDITTABLE3
43	BUSINESS_UNIT_PF	Character(5)	VARCHAR2(5) NOT NULL	Perf Measurement business unit Prompt Table: BUS_UNIT_TBL_PF
44	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: %EDITTABLE
45	SETID_ACTIVITY	Character(5)	VARCHAR2(5) NOT NULL	Activity SetID
46	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: %EDITTABLE2
47	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RES_TYPE
48	SETID_RESOURCE	Character(5)	VARCHAR2(5) NOT NULL	Resource SetID
49	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDITTABLE4
50	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDITTABLE5
51	TASK	Character(5)	VARCHAR2(5) NOT NULL	Task Prompt Table: TL_TASK
52	USER_FIELD_1	Character(10)	VARCHAR2(10) NOT NULL	User Field 1 Prompt Table: TL_USER_FIELD_1
53	USER_FIELD_2	Character(10)	VARCHAR2(10) NOT NULL	User Field 2 Prompt Table: TL_USER_FIELD_2
54	USER_FIELD_3	Character(15)	VARCHAR2(15) NOT NULL	User Field 3 Prompt Table: TL_USER_FIELD_3
55	USER_FIELD_4	Character(20)	VARCHAR2(20) NOT NULL	User Field 4 Prompt Table: TL_USER_FIELD_4
56	USER_FIELD_5	Character(20)	VARCHAR2(20) NOT NULL	User Field 5 Prompt Table: TL_USER_FIELD_5
57	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account
58	DEPTID_CA	Character(10)	VARCHAR2(10) NOT NULL	Department
59	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account
60	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Default Value: PROJ_ACTIVITY.PROJECT_ID Prompt Table: %EDIT_DEPT
61	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField
62	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField
63	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code
64	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field
65	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField
66	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference
67	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate
68	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1
69	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate
70	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1
71	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2
72	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3
73	TRC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	TRC Type A=Amount H=Hours U=Units
74	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage
75	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
76	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
77	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
78	PC_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	PC Distribution Status B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged
79	TL_TIME_TO_PAY	Character(1)	VARCHAR2(1) NOT NULL	Send Time to Payroll