EMPLIDSHEET_IDEXPENSE_TYPELANGUAGE_CDEX_SHEET_LN_VL4(SQL View) |
Index Back |
|---|---|
Expense Sheet Line ViewExpense Sheet Line Information |
| SELECT A.EMPLID , B.SHEET_ID , B.EXPENSE_TYPE , C.LANGUAGE_CD , C.DESCR , C.DESCRSHORT FROM PS_EX_SHEET_HDR A , PS_EX_SHEET_LINE B , PS_EX_MBL_TYPE_LVW C , PS_SET_CNTRL_REC CNTRLREC , ps_ex_ee_org_dtl D WHERE B.SHEET_ID = A.SHEET_ID AND D.EMPLID = A.EMPLID AND D.dflt_ee_prof_flg = 'Y' AND CNTRLREC.recname='EX_TYPES_TBL' AND C.EXPENSE_TYPE = B.EXPENSE_TYPE AND C.SETID = CNTRLREC.SETID AND CNTRLREC.SETCNTRLVALUE = D.business_unit_gl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 3 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | EX_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Expense Type Description |
| 6 | EX_TYPE_DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Expense Type Description |