CNT_BY_TMPL_ESP

(SQL Table)
Index Back

Contracts by Template

This tables stores the elegible Contracts per Template. That is, all the contracts that use the same template.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: ESP

Prompt Table: SET_VLD_HR_09

2 CNT_TEMPLT_ID_ESP Character(11) VARCHAR2(11) NOT NULL SPEE Template ID
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type

Prompt Table: PERS_CNTRCT_TYP

5 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive