TRN_T_SIMUL_ESP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	YEARCD	Character(4)	VARCHAR2(4) NOT NULL	Calendar Year
3	TRN_T_CMPNY_ESP	Character(1)	VARCHAR2(1) NOT NULL	New Company Y/N Table Edit Default Value: N
4	TRN_T_CENTER_ESP	Character(1)	VARCHAR2(1) NOT NULL	New Center C=New Company N=None Y=New Work Center Default Value: N
5	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	FTE Percentage
6	TRN_T_WRKS_ESP	Number(6,0)	INTEGER NOT NULL	Average Workers Previous Year
7	TRN_T_HIRE_ESP	Number(6,0)	INTEGER NOT NULL	Hired Workers Current Year
8	TRN_T_PR_TR_ESP	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Professional Training Fee
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: EUR Prompt Table: CURRENCY_CD_TBL
10	TRN_T_CRED1_ESP	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Total Credit
11	TRN_T_CRED2_ESP	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Credit Used
12	TRN_T_CRED3_ESP	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Available Credit
13	TRN_T_PRVT_CST_ESP	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Private Contribution
14	TRN_T_PRVT_SUM_ESP	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Used Private Contributn
15	TRN_T_RLT_RSLT_ESP	Character(1)	VARCHAR2(1) NOT NULL	Discrepancy Solved in 15 days Y/N Table Edit
16	TRN_T_RLT_REPT_ESP	Character(1)	VARCHAR2(1) NOT NULL	Reported to RLT Y/N Table Edit
17	TRN_T_RLT_VAL_ESP	Character(1)	VARCHAR2(1) NOT NULL	RLT Report D=Discrepancy F=Favorable N=No Answer
18	TRN_T_RLT_DATE_ESP	Date(10)	DATE	Discrepancy Date