| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERSON_NAME
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
GPJP_UC_TERM_DATE |
Date(10) |
DATE NOT NULL |
Unemployement Cert
Default Value: %date
|
| 4 |
GPJP_WC_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Checkbox that indicates whether a payee being processed is for Wage Certificate or Unemployment Certificate.
|
| 5 |
GPJP_UC_NOTE |
Character(254) |
VARCHAR2(254) NOT NULL |
Particular note about wage (23)
|
| 6 |
GPJP_UC_TERM_RSN |
Character(3) |
VARCHAR2(3) NOT NULL |
UC termination reason
001=Bankrupcy or Suspension
002=Closing or no reopening
003=Mandatory Retirement
004=Expiration of Contract
005=Expiration of term of contract
006=Early or Elective Retirement
007=Intercompany transfer
008=Dismissal (no heavy accusatn)
009=Dismissal w/ heavy accusation
010=Layoff due to downsizing
011=Other Voluntary Early Retiremt
012=Issues on Working Condition
013=Other Workplace Circumstances
014=Concern caused by layoff
015=Diffculty to adapt to change
016=Difficulty to commute
017=Other Circumstance
018=Personal Reason
019=Other reason of termination
020=ContEmployment(I Hope)
021=ContEmployment(I Do Not Hope)
022=Other Circumstance
|
| 7 |
GPJP_UC_RETIRE_AGE |
Number(2,0) |
SMALLINT NOT NULL |
Retirement Age (25)
|
| 8 |
GPJP_UC_MTH_CONTR |
Number(3,0) |
SMALLINT NOT NULL |
Month of each contract (26)
|
| 9 |
GPJP_UC_TOT_MTH |
Number(3,0) |
SMALLINT NOT NULL |
Total Months of Service (27)
|
| 10 |
GPJP_UC_NUM_UPDT |
Number(3,0) |
SMALLINT NOT NULL |
Num of Update of the contract
|
| 11 |
GPJP_UC_CON_RENEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract States renewal condition
D=N (Unstated)
N=N (Stated, w/Empl End Notice)
N=Unstated
O=N (Stated,w/o Empl End Notice)
Y=Stated
|
| 12 |
GPJP_UC_TRAINING |
Character(1) |
VARCHAR2(1) NOT NULL |
Training (31)
N=No Company did not gave traing
Y=Yes, Company gave training
|
| 13 |
GPJP_UC_TERM_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Contract was terminated by (29)
1=Requested as Preferred
2=Requested as Non-Preferred
3=No Request Was Made
E=Employee
E=Employee
R=Employer
R=Employer
|
| 14 |
GPJP_UC_OLD_LOC |
Character(8) |
VARCHAR2(8) NOT NULL |
Old Location
|
| 15 |
GPJP_UC_NEW_LOC |
Character(8) |
VARCHAR2(8) NOT NULL |
New Location (32-2)
|
| 16 |
GPJP_UC_REASON |
Character(100) |
VARCHAR2(100) NOT NULL |
Reason
|
| 17 |
GPJP_UC_ELIGIBLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Eligible to print UC; default is Y
Y/N Table Edit
Default Value: Y
|
| 18 |
GPJP_UC_OVER59 |
Character(1) |
VARCHAR2(1) NOT NULL |
Over 59
Y/N Table Edit
Default Value: Y
|
| 19 |
GPJP_UC_UPDT_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Updated By
1=System
2=User
Default Value: 1
|
| 20 |
GPJP_UC_UPDT_ON |
Date(10) |
DATE |
UC Update On
Default Value: %date
|
| 21 |
GPJP_UC_STATEMENT |
Long Character |
CLOB |
Statement of the situation on the termination (35)
|
| 22 |
GPJP_UC_CONT_EMPL |
Character(2) |
VARCHAR2(2) NOT NULL |
Unemployment Certificate, Continuous Employment After Mandatory Termination options(a,b,c)
A=Option A
B=Option B
C=Option C
|