GPFR_ASS_PRINT2

(SQL Table)
Index Back

ASSEDIC: Crystal Link

ASSEDIC: Crystal Link. Used as link between Crystal Report and PS. Comon employees to print.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
5 LAST_DATE_WORKED Date(10) DATE Last Date Worked
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_AT_PRINT Character(1) VARCHAR2(1) NOT NULL GPFR: Row to Print

Y/N Table Edit

Default Value: N

8 GPFR_ASS_SECU_NBR Number(12,0) DECIMAL(12) NOT NULL GPFR: UNEDIC Security Number