SETIDAM_FDRL_RULEEFFDTCATEGORYPrompt Table: CATEGORY_TBL
AM_FDRL_RUL2_VW(SQL View) |
Index Back |
|---|---|
AM Federal Asset Rule Detail |
| SELECT DISTINCT SETID , AM_FDRL_RULE , EFFDT , CATEGORY FROM PS_AM_FDRL_RUL_DTL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | AM_FDRL_RULE |
Character(10) | VARCHAR2(10) NOT NULL | AM Federal Asset Rules field |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | CATEGORY |
Character(5) | VARCHAR2(5) NOT NULL |
Asset Category
Prompt Table: CATEGORY_TBL |