TL_RPT_CDVAL (SQL Table)	Index Back
Reporting - TCD Task Elem Cd Table to hold results of Task Element Codes populated in the TCD Outbound interface. This table is needed to faciliate running of reports using a known table, rather than having the report process need to know which image of WRK_CDVAL_TAO was used for a particular run of the TCD Outbound Interface.

TL_RPT_CDVAL

(SQL Table)

Reporting - TCD Task Elem Cd

Table to hold results of Task Element Codes populated in the TCD Outbound interface. This table is needed to faciliate running of reports using a known table, rather than having the report process need to know which image of WRK_CDVAL_TAO was used for a particular run of the TCD Outbound Interface.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In Process

3 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values

4 TCD_ID Character(10) VARCHAR2(10) NOT NULL Time Collection Device Identification.

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

6 TCD_NETWORK_ID Character(20) VARCHAR2(20) NOT NULL Network ID

7 TCD_NODE_ID Character(20) VARCHAR2(20) NOT NULL Terminal ID

8 TASK_ELEMENT_CD Character(3) VARCHAR2(3) NOT NULL Task Element Code

9 TASK_ELEMENT_VAL Character(25) VARCHAR2(25) NOT NULL Task Element Value

10 VALUE_SOURCE Character(2) VARCHAR2(2) NOT NULL Value Source
FS=Financials
PC=Project Costing
TL=Time and Labor

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In Process
3	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
4	TCD_ID	Character(10)	VARCHAR2(10) NOT NULL	Time Collection Device Identification.
5	MSGNODENAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
6	TCD_NETWORK_ID	Character(20)	VARCHAR2(20) NOT NULL	Network ID
7	TCD_NODE_ID	Character(20)	VARCHAR2(20) NOT NULL	Terminal ID
8	TASK_ELEMENT_CD	Character(3)	VARCHAR2(3) NOT NULL	Task Element Code
9	TASK_ELEMENT_VAL	Character(25)	VARCHAR2(25) NOT NULL	Task Element Value
10	VALUE_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Value Source FS=Financials PC=Project Costing TL=Time and Labor