TRW_DATASRC_TBL (SQL Table)	Index Back
TRW Data Source Table This record is the parent table for the Reward Data Source attributes. This table stores general information about the Reward Data Source.

TRW_DATASRC_TBL

(SQL Table)

TRW Data Source Table

This record is the parent table for the Reward Data Source attributes. This table stores general information about the Reward Data Source.

Related Language Record: TRW_DSRC_TBL_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRW_DATASRC_ID Character(15) VARCHAR2(15) NOT NULL Total rewards statement - Reward Data Source ID

2 TRW_DESCR50 Character(50) VARCHAR2(50) NOT NULL Description field character 50

3 TRW_DESCRLONG Long Character CLOB TRW Description Long

4 TRW_DATASRC_CAT Character(3) VARCHAR2(3) NOT NULL Total Rewards Statement - Data Source Category
ABS=Absence Management
BLV=Benefit Leave Accrual
EXT=External Data
GP=Global Payroll
NAP=North American Payroll
STK=Stock Administration

5 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N

6 TRW_EXT_TMP_TBL Character(15) VARCHAR2(15) NOT NULL Total Rewards Statement - Extract Temporary Table
Prompt Table: TRW_RECDEFN

7 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

8 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRW_DATASRC_ID	Character(15)	VARCHAR2(15) NOT NULL	Total rewards statement - Reward Data Source ID
2	TRW_DESCR50	Character(50)	VARCHAR2(50) NOT NULL	Description field character 50
3	TRW_DESCRLONG	Long Character	CLOB	TRW Description Long
4	TRW_DATASRC_CAT	Character(3)	VARCHAR2(3) NOT NULL	Total Rewards Statement - Data Source Category ABS=Absence Management BLV=Benefit Leave Accrual EXT=External Data GP=Global Payroll NAP=North American Payroll STK=Stock Administration
5	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: N
6	TRW_EXT_TMP_TBL	Character(15)	VARCHAR2(15) NOT NULL	Total Rewards Statement - Extract Temporary Table Prompt Table: TRW_RECDEFN
7	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
8	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.