TC_CATEGORY_WRK

(SQL Table)
 Index Back

Benefit Statement temp table

This is a temp table used in the Benefits statement SQR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPENSATION_ID Character(10) VARCHAR2(10) NOT NULL Compensation ID
2 TC_CATEGORY1 Character(10) VARCHAR2(10) NOT NULL Category Name
3 TC_CATEGORY2 Character(10) VARCHAR2(10) NOT NULL Category Name
4 TC_CATEGORY3 Character(10) VARCHAR2(10) NOT NULL Category Name
5 TC_CATEGORY4 Character(10) VARCHAR2(10) NOT NULL Category Name
6 TC_CATEGORY5 Character(10) VARCHAR2(10) NOT NULL Category Name
7 TC_CATEGORY6 Character(10) VARCHAR2(10) NOT NULL Category Name
8 TC_CATEGORY7 Character(10) VARCHAR2(10) NOT NULL Category Name
9 TC_CATEGORY8 Character(10) VARCHAR2(10) NOT NULL Category Name
10 TC_CATEGORY9 Character(10) VARCHAR2(10) NOT NULL Category Name
11 TC_CATEGORY10 Character(10) VARCHAR2(10) NOT NULL Category Name
12 TC_CATEGORY11 Character(10) VARCHAR2(10) NOT NULL Category Name
13 TC_CATEGORY12 Character(10) VARCHAR2(10) NOT NULL Category Name
14 TC_CATEGORY13 Character(10) VARCHAR2(10) NOT NULL Category Name
15 TC_CATEGORY14 Character(10) VARCHAR2(10) NOT NULL Category Name