EX_SHEETHDR_VWL(SQL View) |
Index Back |
---|---|
Expense Sheet HeaderThis is one of the core records for Expenses. It is the highest level definition for an Expense Sheet. The key is SHEET_ID, which is generated automatically by the system by using a counter that exists on INSTALLTION_EX. |
SELECT A.SHEET_ID , D.LANGUAGE_CD , B.XLATLONGNAME , D.DESCR FROM PS_EX_SHEET_HDR A LEFT OUTER JOIN PS_EX_PURPOSE_VLNG D ON D.SETID = A.SETID AND D.BUSINESS_PURPOSE = A.BUSINESS_PURPOSE , XLATTABLE_VW B , PS_PERSONAL_DATA C WHERE B.FIELDNAME = 'SHEET_STATUS' AND B.FIELDVALUE = A.SHEET_STATUS AND A.EMPLID=C.EMPLID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL |
Report ID
Default Value: NEXT |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | SHEET_STATUS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Sheet Status Description |
4 | PURPOSE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business Purpose |