SETCNTRLVALUECHARTFIELDTREE_NAMEEFFDTA=Active
I=Inactive
TREE_SUMCHRT_VW(SQL View) |
Index Back |
|---|---|
Summary ledger tree CF |
| select d.setcntrlvalue, c.chartfield, a.tree_name, a.effdt, a.eff_status, a.descr from PSTREEDEFN a, ps_led_defn_tbl b, ps_led_flds_tbl c, ps_set_cntrl_rec d where a.tree_name=c.tree_name and c.setid=d.setid and b.setid=c.setid and b.ledger=c.ledger and b.ledger_type = 'S' and d.recname='LED_FLDS_TBL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETCNTRLVALUE |
Character(20) | VARCHAR2(20) NOT NULL | Tree Definition User Key Value |
| 2 | CHARTFIELD |
Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 3 | TREE_NAME |
Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 4 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |