TC_ORG_VW

(SQL View)
Index Back

A view of TC_EE_DETAIL

This is a view of TC_EE_DETAIL table. It concats the setid with their field like TC_SETID_DETP = SETID || DEPTID.

SELECT TC_PLAN_ID , EFFDT , COMPENSATION_ID , TC_COMP_SOURCE_ID , THRU_DATE , GB_GROUP_ID , EMPLID , EMPL_RCD , FROM_CURR_CD , SEQNUM , FROM_DATE , COMPANY , BUSINESS_UNIT , %TrimSubstr(SETID_LOCATION,1,5) %Concat %TrimSubstr(LOCATION ,1 ,10) , %TrimSubstr(SETID_DEPT,1,5) %Concat %TrimSubstr(DEPTID,1,10) , %TrimSubstr(SETID_JOBCODE,1,5) %Concat %TrimSubstr(JOBCODE,1,6) , POSITION_NBR , %TrimSubstr(SETID_SALARY,1,5) %Concat %TrimSubstr(SAL_ADMIN_PLAN,1,4) %Concat %TrimSubstr(GRADE,1,3) , VCOMP_FLAG , %TrimSubstr(SETID_LBR_AGRMNT,1,5) %Concat %TrimSubstr(LABOR_AGREEMENT,1,6) %Concat %TrimSubstr(EMPL_CTG,1,6) , FROM_COMP_AMT , FROM_PAYROLL_AMT , TO_COMP_AMT , TO_PAYROLL_AMT , %TrimSubstr(SETID_LBR_AGRMNT,1,5) %Concat %TrimSubstr(LABOR_AGREEMENT,1,6) FROM PS_TC_EE_DETAIL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TC_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Total Comp Plan ID

Prompt Table: TC_PLAN

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %Date

Prompt Table: TC_PLAN_VW

3 COMPENSATION_ID Character(10) VARCHAR2(10) NOT NULL Compensation ID

Prompt Table: TC_COMP_DEFN

4 TC_COMP_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Compensation Source

Prompt Table: TC_COMP_SOURCE

5 THRU_DATE Date(10) DATE NOT NULL Thru Date

Default Value: TC_PLAN.THRU_DATE

6 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

Default Value: JOB.EMPL_RCD

9 FROM_CURR_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
11 FROM_DATE Date(10) DATE NOT NULL From Date

Default Value: TC_PLAN.FROM_DATE

12 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Default Value: JOB.COMPANY

13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: JOB.BUSINESS_UNIT

14 TC_SETID_LOCATION Character(15) VARCHAR2(15) NOT NULL Location
15 TC_SETID_DEPT Character(15) VARCHAR2(15) NOT NULL Department ID
16 TC_SETID_JOBCODE Character(11) VARCHAR2(11) NOT NULL Job Code
17 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number

Default Value: JOB.POSITION_NBR

18 TC_SETID_SALPLAN Character(12) VARCHAR2(12) NOT NULL Salary Plan and Step
19 VCOMP_FLAG Character(1) VARCHAR2(1) NOT NULL Variable Compensation Flag
20 TC_EMPL_CTG Character(17) VARCHAR2(17) NOT NULL TC - Employee Categorization
21 FROM_COMP_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Compensation Amount
22 FROM_PAYROLL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Payroll Amount
23 TO_COMP_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Converted Compensation Amount
24 TO_PAYROLL_AMT Signed Number(20,3) DECIMAL(18,3) NOT NULL Converted Payroll Amount
25 TC_SETID_LA Character(15) VARCHAR2(15) NOT NULL Labor Agreement