TC_PLAN(SQL Table) |
Index Back |
|---|---|
Total Comp Plan DefinitionThis record allows the user to define a Total Compensation Plan which logically groups compensation and business units as well as logical unit of separation of Total Compensation extracts. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TC_PLAN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Total Comp Plan ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | FROM_DATE | Date(10) | DATE NOT NULL | From Date |
| 4 | THRU_DATE | Date(10) | DATE NOT NULL | Thru Date |
| 5 | TC_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
Period Frequency
A=Annually M=Monthly Q=Quarterly Default Value: A |
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 7 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Base Currency
Prompt Table: CURRENCY_CD_TBL |
| 8 | CUR_EFFDT | Date(10) | DATE | Currency Effective Date |
| 9 | TC_FROZEN | Character(1) | VARCHAR2(1) NOT NULL |
Plan Frozen
N=No Y=Yes Default Value: N |
| 10 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: TC_VALID_TREES |
| 11 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 12 | CUR_EFFDT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Effective Date Flag
E=Effective Date P=Period Thru Date Default Value: E |
| 13 | COMMENTS | Long Character | CLOB | Comment |