ADJCODECLSVWLNG(SQL View) |
Index Back |
---|---|
Class Withdraw/Cancel Adj CdADJCODECLSVWLNG is the language record view related to ADJ_CODE_CLS_VW |
SELECT DISTINCT A.SETID , C.STRM , A.ADJ_TERM_CD , D.LANGUAGE_CD , D.DESCR FROM PS_ADJ_CODE_TBL A , PS_ADJ_REASON_TBL B , PS_ADJ_TERM_CD_TBL C , PS_ADJ_CODE_TBLLNG D WHERE A.SETID = B.SETID AND A.ADJ_TERM_CD = B.ADJ_TERM_CD AND B.WITHDRAW_FLAG = 'N' AND C.SETID = B.SETID AND C.ADJ_TERM_CD = B.ADJ_TERM_CD AND C.ADJUST_REASON = B.ADJUST_REASON AND A.ADJUST_OPTION <> 'E' AND A.SETID = D.SETID AND A.ADJ_TERM_CD = D.ADJ_TERM_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_CS.SETID |
2 | STRM | Character(4) | VARCHAR2(4) NOT NULL | Term |
3 | ADJ_TERM_CD | Character(8) | VARCHAR2(8) NOT NULL | Adjustment Code |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |