CONTRACT(SQL Table) |
Index Back |
|---|---|
Employment Contract DataCONTRACT contains all contract information for employees with a compensation frequency of 'Contract'. It specifies contract begin and end dates, payment begin and end dates and an optional contract type. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | CONTRACT_BEGIN_DT | Date(10) | DATE NOT NULL | Contract Begin Date |
| 5 | CONTRACT_END_DT | Date(10) | DATE NOT NULL | Contract End Date |
| 6 | PAYMENT_BEGIN_DT | Date(10) | DATE | Payment Begin Date |
| 7 | PAYMENT_END_DT | Date(10) | DATE | Payment End Date |
| 8 | 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 |
| 9 | CONTRACT_PAY_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
Contract Pay Type
Prompt Table: CNTRCT_TYPE_TBL |
| 10 | CNT_RENEWAL_INDIC | Character(1) | VARCHAR2(1) NOT NULL |
Public Sector HRMS extension.
This field is used to indicate the eligibility of an employee pay contract for automatic renewal by a batch process (CNTPAY02.SQR) at expiry.
Y/N Table Edit Default Value: N |
| 11 | CNT_RENEWAL_COUNT | Number(2,0) | SMALLINT NOT NULL |
Public Sector Extension
This field indicates the number of remaining renewals left for an employee's contract.
Default Value: 0 |
| 12 | PAY_PERIOD_HRS | Number(6,2) | DECIMAL(5,2) NOT NULL | Pay Period Hours |
| 13 | ASSIGN_HRS_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Assign Hours To Flag
A=All Earnings(Contract+PNE+ENP) C=Contract Earnings Only N=Not Applicable Default Value: N |
| 14 | FREQ_ID_MONTHLY | Character(5) | VARCHAR2(5) NOT NULL |
Monthly Frequency
Default Value: CNTRCT_TYPE_TBL.FREQ_ID_MONTHLY Prompt Table:
MTH_FREQ_TBL_VW
|
| 15 | CONTRACT_TERM_DT | Date(10) | DATE | Contract Termination Date - reflects actual termination of contract e.g. if employee terminates or transfer to a non-contract pay position. Default value = Contract end date |
| 16 | ADDL_SEQ | Number(2,0) | SMALLINT NOT NULL |
Additional Pay Sequence Number
Default Value: 1 |
| 17 | HP_TRACK_ACTUALS | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate if Actual Earnings need to be tracked for a contract pay employee
Y/N Table Edit Default Value: N |
| 18 | HP_WORKDAYS | Number(3,0) | SMALLINT NOT NULL | Stores actual work days for contract period |
| 19 | HP_CONTRACT_START | Date(10) | DATE | Actual Start Date of contract |
| 20 | HP_PAID_TO_DT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Contract Pay Earnings Paid to Date |
| 21 | HP_EARNED_TO_DT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Contract pay earnings actually earned to date based on number of work days |
| 22 | HP_WORKED_TO_DT | Number(3,0) | SMALLINT NOT NULL | Actuals Days worked to date in contract period |
| 23 | HP_USE_HOL_SCHD | Character(1) | VARCHAR2(1) NOT NULL |
To specify if Holiday Schedule is referenced
Y/N Table Edit Default Value: N |