GPFR_ASS_PRINT (SQL Table)	Index Back
ASS: Printing Select Result ASSEDIC: Printing Select Result. Used to display the result of employees to print and to select the one the end-user wants to print.

GPFR_ASS_PRINT

(SQL Table)

ASS: Printing Select Result

ASSEDIC: Printing Select Result. Used to display the result of employees to print and to select the one the end-user wants to print.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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

3 GPFR_AT_PRINT Character(1) VARCHAR2(1) NOT NULL GPFR: Row to Print
Y/N Table Edit
Default Value: N

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

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

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

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

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

9 LAST_DATE_WORKED Date(10) DATE Last Date Worked

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	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
3	GPFR_AT_PRINT	Character(1)	VARCHAR2(1) NOT NULL	GPFR: Row to Print Y/N Table Edit Default Value: N
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
5	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
6	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
7	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
8	GPFR_ASS_PRINT_IND	Character(1)	VARCHAR2(1) NOT NULL	GPFR: Printing Already Requested
9	LAST_DATE_WORKED	Date(10)	DATE	Last Date Worked