GPFR_GAR_DAT_VW(SQL View) |
Index Back |
|---|---|
Garnishment DataGarnishment Data |
| SELECT A.EMPLID , A.EMPL_RCD , A.GPFR_ROW_NUM , CASE WHEN %Sql(FUNCLIB_GP_GETCHARLENGTH, A.GPFR_GAR_ID) <= 20 THEN %Substring(A.GPFR_GAR_ID, 1, %sql(FUNCLIB_GP_GETCHARLENGTH, A.GPFR_GAR_ID)) ELSE %Substring(A.GPFR_GAR_ID, 1, 20) END , A.GPFR_GAR_TYP , A.GPFR_GAR_AMOUNT , A.GPFR_BGN_DT , A.GPFR_END_DT , A.GPFR_SATD_FLG , A.GPFR_SKIP , A.RECIPIENT_ID , A.GPFR_INSTANCE , A.INSTANCE , %Coalesce(C.RECIPIENT_TAG, 0) , A.PIN_NUM , A.GPFR_PI_STATUS , A.GPFR_EFFDT_CREATED , CASE WHEN %Sql(FUNCLIB_GP_GETCHARLENGTH, A.GPFR_GAR_ID) <= 25 THEN %Substring(A.GPFR_GAR_ID, 1, %sql(FUNCLIB_GP_GETCHARLENGTH, A.GPFR_GAR_ID)) ELSE %Substring(A.GPFR_GAR_ID, 1, 25) END , CASE WHEN %Sql(FUNCLIB_GP_GETCHARLENGTH, A.GPFR_GAR_ID) > 25 THEN %Substring(A.GPFR_GAR_ID, 26, %sql(FUNCLIB_GP_GETCHARLENGTH, A.GPFR_GAR_ID) - 25) ELSE ' ' END FROM PS_GPFR_GAR_DAT A LEFT OUTER JOIN PS_GP_RCP_PYE_DTL C ON A.EMPLID=C.EMPLID AND A.EMPL_RCD=C.EMPL_RCD AND A.GPFR_BGN_DT=C.EFFDT AND A.PIN_NUM= C.PIN_NUM AND A.RECIPIENT_ID = C.RECIPIENT_ID AND A.GPFR_INSTANCE=C.RECIPIENT_TAG , PS_GP_PIN B WHERE A.PIN_NUM = B.PIN_NUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | GPFR_ROW_NUM |
Number(5,0) | INTEGER NOT NULL | Used as counter for row or column number |
| 4 | GPFR_GAR_ID |
Character(40) | VARCHAR2(40) NOT NULL | Identification of the garnishment |
| 5 | GPFR_GAR_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Type of the garnishment
1=Alimony 2=Tax 3=Penal Sentence 4=Other |
| 6 | GPFR_GAR_AMOUNT | Number(13,2) | DECIMAL(12,2) NOT NULL | Amount for garnishment data |
| 7 | GPFR_BGN_DT | Date(10) | DATE | Begin Date |
| 8 | GPFR_END_DT | Date(10) | DATE | End Date |
| 9 | GPFR_SATD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Administrative seizure by third party (SATD)
Y/N Table Edit Default Value: N |
| 10 | GPFR_SKIP | Character(1) | VARCHAR2(1) NOT NULL |
Skip the row in the loan schedule
Y/N Table Edit Default Value: N |
| 11 | RECIPIENT_ID | Character(8) | VARCHAR2(8) NOT NULL |
Payment recipient ID
Prompt Table: GPFR_RECIP_I_VW |
| 12 | GPFR_INSTANCE | Number(1,0) | SMALLINT NOT NULL | Number of the deduction to be used (from the setup), for loan and garnishment |
| 13 | INSTANCE | Number(3,0) | SMALLINT NOT NULL | Instance Number |
| 14 | RECIPIENT_TAG | Number(3,0) | SMALLINT NOT NULL | Used to identify recipients for E/D, PI |
| 15 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 16 | GPFR_PI_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Status of the positive inputs (created, processed, ...)
CR=Created ER=Error PI=Awaiting PR=Processed RE=Removed UP=Updated Default Value: CR |
| 17 | GPFR_EFFDT_CREATED | Character(1) | VARCHAR2(1) NOT NULL | Used to store the effective date *before* any modification |
| 18 | GPFR_GAR_ID1 | Character(25) | VARCHAR2(25) NOT NULL | Identification of the garnishment 1/2 |
| 19 | GPFR_GAR_ID2 | Character(25) | VARCHAR2(25) NOT NULL | Identification of the garnishment 2/2 |