EFFDTDefault Value: %date
EX_LOCTN_KIB_VW(SQL View) |
Index Back |
|---|---|
Expenses Location Setid ViewExpense Location Setid View for Insights |
| SELECT J.SETID , J.SETCNTRLVALUE , L.TXN_LOCATION , L.EFFDT , L.DESCR FROM PS_SET_CNTRL_REC J , PS_EX_LOCATION_VW L WHERE J.RECNAME = 'EX_LOCATION_TBL' AND J.REC_GROUP_ID = ( SELECT M.REC_GROUP_ID FROM PS_REC_GROUP_REC M WHERE M.RECNAME = 'EX_LOCATION_TBL') AND J.SETID = L.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SETCNTRLVALUE | Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 3 | TXN_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Expense Location |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |