Credit Union Deductions - Core-CT



CT_OSC_RP_CMRP9301_DED_BY_CU

Purpose of Query

Credit Union Deductions - This query displays credit union deductions.

Folder

RETPY

Tables

CTW_RET_DET_PAY

Prompts

PAY_END_DT=

Criteria

A.CT_TRANSACTION_CD is in list (‘RCUCSE’,’RCUCSP’,’RCULAB’,’RCUSTP’,’RCUWCF’)

Sample Data

[pic]

Fields

|Col |Record.Fieldname |Format |Ord |XLAT |Agg |Heading Text |

|1 |A.EMPLID – Empl ID |Char11 | | | |ID |

|2 |A.NAME – Name |Char50 |2 | | |Name |

|3 |A.DEPTID – Department |Char10 | | | |DeptID |

|4 |A.CT_TRANSACTION_CD – Transaction Code |Char6 |1 | | |Trans Code |

|5 |A.CT_TRANS_CD_DESCR – Transaction Code Description |Char30 | | | |Trns Cd Descr |

|6 |A.CHECK_DT – Paycheck Issue Date |Date | | | |Check Dt |

|7 |A.CT_AMOUNT – Transaction Amount |SNm13.2 | | | |Trans Amt |

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download