GPFR_ASS_SRCH4 (SQL View)	Index Back
Ass: scrollselect basic view Assedic: scrollselect basic view

GPFR_ASS_SRCH4

(SQL View)

Ass: scrollselect basic view

Assedic: scrollselect basic view

SELECT A.CAL_RUN_ID , A.COMPANY , A.ESTABID , A.EMPLID , A.EMPL_RCD , B.GPFR_ASS_BREACH , A.GPFR_ASS_PRINT_IND , A.LAST_DATE_WORKED , SEC.OPRID FROM PS_GPFR_ASS_COMP A , PS_GPFR_ASS_PAYEE B %Sql(GPFR_SECU_EMPLMT_SQL, SEC) AND A.EMPLID = B.EMPLID AND A.LAST_DATE_WORKED = B.LAST_DATE_WORKED AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.EMPL_RCD = B.EMPL_RCD GROUP BY A.CAL_RUN_ID , A.COMPANY , A.ESTABID , A.EMPLID , A.EMPL_RCD , A.LAST_DATE_WORKED , B.GPFR_ASS_BREACH , A.GPFR_ASS_PRINT_IND , SEC.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

3 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

6 GPFR_ASS_BREACH Character(2) VARCHAR2(2) NOT NULL GPFR: Reason of Breach of Contract
11=Receivership or Wound Up
12=Definitive Closing of Estab
14=Redundancy
15=Site Ending
20=Other Dismissal reason
25=Other Redundancy Breach
31=End of Fixed-Term Contract
32=End of Interim Mission
34=Employer's End Probation Time
35=Payee's End Probation Time
36=Employer's anticipated Breach
37=Payee's Anticipated Breach
38=Pension Payee Off
39=Retirement
59=Resignation
60=Other Breach reason
70=Completion of Int Cpny Trans
71=Employee Request
72=Intercompany Transfer
73=Internal Recruitment
74=Manager Request
75=Promotion
76=Reorganization
77=Supervisor Level Advance
78=Transfer to Affilate
81=End of Apprenticeship Contract
82=Contract Judicial termination
83=Event Beyond one's Control
84=Agreement Breach of App or CDD

7 GPFR_ASS_PRINT_IND Character(1) VARCHAR2(1) NOT NULL GPFR: Printing Already Requested

8 LAST_DATE_WORKED Date(10) DATE Last Date Worked

9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
3	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
6	GPFR_ASS_BREACH	Character(2)	VARCHAR2(2) NOT NULL	GPFR: Reason of Breach of Contract 11=Receivership or Wound Up 12=Definitive Closing of Estab 14=Redundancy 15=Site Ending 20=Other Dismissal reason 25=Other Redundancy Breach 31=End of Fixed-Term Contract 32=End of Interim Mission 34=Employer's End Probation Time 35=Payee's End Probation Time 36=Employer's anticipated Breach 37=Payee's Anticipated Breach 38=Pension Payee Off 39=Retirement 59=Resignation 60=Other Breach reason 70=Completion of Int Cpny Trans 71=Employee Request 72=Intercompany Transfer 73=Internal Recruitment 74=Manager Request 75=Promotion 76=Reorganization 77=Supervisor Level Advance 78=Transfer to Affilate 81=End of Apprenticeship Contract 82=Contract Judicial termination 83=Event Beyond one's Control 84=Agreement Breach of App or CDD
7	GPFR_ASS_PRINT_IND	Character(1)	VARCHAR2(1) NOT NULL	GPFR: Printing Already Requested
8	LAST_DATE_WORKED	Date(10)	DATE	Last Date Worked
9	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).