|
SELECT B.EMPLID ,A.CONTRACT_NUM ,A.CONTRACT_BEGIN_DT ,A.CONTRACT_END_DT ,A.SIGNATURE_DT ,A.CONTRACT_STATUS ,A.ADD_CONTRACT ,A.CNT_MIN_HRS ,A.CNT_MAX_HRS ,A.RESPONSIBLE_ID ,A.YEAR_SW ,A.COMMENTSHORT ,A.CNT_TEMPLATE_ID ,%subrec(HRS_CNT_ESP_SBR,A) ,A.CONTRCT_EXP_END_DT ,A.REG_REGION ,A.COMMENTS ,B.HRS_HIRE_SEQ FROM PS_HRS_APP_CNTRACT A , PS_HRS_HIRE B WHERE A.HRS_PERSON_ID = B.HRS_PERSON_ID
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract Number
|
| 3 |
CONTRACT_BEGIN_DT |
Date(10) |
DATE |
Contract Begin Date
Default Value: %Date
|
| 4 |
CONTRACT_END_DT |
Date(10) |
DATE |
Contract End Date
|
| 5 |
SIGNATURE_DT |
Date(10) |
DATE |
Signature Date
|
| 6 |
CONTRACT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract Status -
The values 'N - N/A' and 'P - Pending' are suppressed from release 8.
A=Active
I=Inactive
Default Value: A
|
| 7 |
ADD_CONTRACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Additional Contract
Y/N Table Edit
Default Value: N
|
| 8 |
CNT_MIN_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Minimum Hours Per Contract
|
| 9 |
CNT_MAX_HRS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Maximum Hours Per Contract
|
| 10 |
RESPONSIBLE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Responsible ID
Prompt Table:
PERSON_NAME
|
| 11 |
YEAR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
More than one year expected
Y/N Table Edit
Default Value: N
|
| 12 |
COMMENTSHORT |
Character(30) |
VARCHAR2(30) NOT NULL |
Short Comment
|
| 13 |
CNT_TEMPLATE_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Contract Template ID
Prompt Table:
CNT_TEMPL_VW
|
| 14 |
BEGIN_WEEKDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Begin/End Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
Default Value: 2
|
| 15 |
END_WEEKDAY |
Character(1) |
VARCHAR2(1) NOT NULL |
End Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
Default Value: 6
|
| 16 |
HIRE_CTR_CD_ESP |
Character(3) |
VARCHAR2(3) NOT NULL |
Hiring Center
Prompt Table:
HRS_HIRCT_ESP_I
|
| 17 |
COMP_RATE_DESCR |
Character(100) |
VARCHAR2(100) NOT NULL |
Compensation Rate Description
|
| 18 |
PROBATION_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Probation Period
|
| 19 |
DURATION_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Type of Duration
D=Days
M=Months
Y=Years
Default Value: M
|
| 20 |
VACATION_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Vacation Period
|
| 21 |
VACN_PERIOD_UNIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Vacation Period Type
D=Work Days
M=Months
N=Natural Days
W=Weeks
Default Value: M
|
| 22 |
SCHEME_ID_ESP |
Character(4) |
VARCHAR2(4) NOT NULL |
Scheme ID - ESP
Prompt Table:
HRS_SCRGM_ESP_I
|
| 23 |
CONTRIB_ID_ESP |
Character(5) |
VARCHAR2(5) NOT NULL |
Soc.Sec. Contribution ID - ESP
Prompt Table:
HRS_RGM_ESP_1_I
|
| 24 |
ACTIVE_RENT_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Security Active Rent
Y/N Table Edit
Default Value: N
|
| 25 |
FIRST_SELFWRKR_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
First self employer worker
Y/N Table Edit
Default Value: N
|
| 26 |
PART_TIME_PERC_ESP |
Number(3,0) |
SMALLINT NOT NULL |
Percentage of Part Time
|
| 27 |
RE_JOIN_DSB_EE_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Joined Disabled Employee
Y/N Table Edit
Default Value: N
|
| 28 |
SOC_EXCLUSION_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Social Exclusion Employee
0=None
1=Social Exclusion
2=Domestic Violence Victim
3=Gender Violence Victim
4=Soc Excl - Insertion Itinerary
5=Soc Excl - Relapse
|
| 29 |
UNEMPLYMNT_CND_ESP |
Character(1) |
VARCHAR2(1) NOT NULL |
Unemployment Condition
1=Booked in Unemployment Office
2=Booked in Office more than 12
3=Agricultural
4=With subsidy over one year
5=Booked in Office more than 6 m
6=With One-yr-remaining Subsidy
7=W/ subsidy. Older than 52 yrs.
A=W/ Benefit. RDL 2/2009
B=With Employability Problems
C=Unemployed at 1-1-2011
D=Unemployed at 1-1-2011. 12/18
E=Unemployed 16-08-2011
F=Unemployed with Family support
G=Unemployed >6 m. Fam Support
H=Under 3 m. of work experience
I=Unemployed from another sector
J=Youth Employment
K=Unemployed w/o Education Certf
M=Part Time<333. RDL 2/2009
P=RDL 3/2014 - Fix rate
R=RDL 1/2015 Reduced rate
|
| 30 |
CONTRCT_EXP_END_DT |
Date(10) |
DATE |
Contract Expected End Date
|
| 31 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_STANDARD_VW
|
| 32 |
COMMENTS |
Long Character |
CLOB |
Comment
|
| 33 |
HRS_HIRE_SEQ |
Number(10,0) |
DECIMAL(10) NOT NULL |
Hire Sequence ID
|