GPFR_ASS_PRINT2(SQL Table) |
Index Back |
---|---|
ASSEDIC: Crystal LinkASSEDIC: 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 |