CONTRACT_PAY_TYPEEFFDTDefault Value: %date
A=Pay Over 12 Months
C=Pay Over Contract
L=Pay with Lump Sum
X=Pay over 'X' months
Default Value: C
Prompt Table:
MTH_FREQ_TBL_VW
Set Control Field: FREQUENCY_ID
CNTRCT_TYPE_TBL(SQL Table) |
Index Back |
|---|---|
Contract Type TableCNTRCT_TYPE_TBL contains each user-defined contract type with its' related descriptions and payment term. It is effective-dated to maintain history, current and future changes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_PAY_TYPE |
Character(10) | VARCHAR2(10) NOT NULL | Contract Pay Type |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | PAYMENT_TERM | Character(1) | VARCHAR2(1) NOT NULL |
Payment Term
A=Pay Over 12 Months C=Pay Over Contract L=Pay with Lump Sum X=Pay over 'X' months Default Value: C |
| 6 | FREQ_ID_MONTHLY | Character(5) | VARCHAR2(5) NOT NULL |
Monthly Frequency
Prompt Table:
MTH_FREQ_TBL_VW
|