PeopleSoft

ps_rolexlatopr - Supervisor data in PeopleSoft

REM INSERTING into PSTREEDEFN
Insert into PSTREEDEFN
(SETID,SETCNTRLVALUE,TREE_NAME,EFFDT,EFF_STATUS,VERSION,TREE_STRCT_ID,DESCR,ALL_VALUES,USE_LEVELS,VALID_TREE,LEVEL_COUNT,
NODE_COUNT,LEAF_COUNT,TREE_HAS_RANGES,DUPLICATE_LEAF,TREE_CATEGORY,TREE_ACC_METHOD,TREE_ACC_SELECTOR,TREE_ACC_SEL_OPT,LASTUPDDTTM,LASTUPDOPRID,TREE_IMAGE,BRANCH_IMAGE,
NODECOL_IMAGE,NODEEXP_IMAGE,LEAF_IMAGE)
values
('SHARE',' ','TESTTREE','01-JAN-00','A',5,'CONSOLIDATION','test','N','S','Y',2,
2,1,'N','N','DEFAULT',' ','S','R',to_timestamp('25-AUG-10 09.31.30.283794000 PM','DD-MON-RR HH.MI.SS.FF AM'),'VP1',' ',' ',
' ',' ',' ');
REM INSERTING into PSTREELEVEL
Insert into PSTREELEVEL (SETID,SETCNTRLVALUE,TREE_NAME,EFFDT,TREE_LEVEL,TREE_LEVEL_NUM,ALL_VALUES) values ('SHARE',' ','TESTTREE','01-JAN-00','1',1,'Y');
Insert into PSTREELEVEL (SETID,SETCNTRLVALUE,TREE_NAME,EFFDT,TREE_LEVEL,TREE_LEVEL_NUM,ALL_VALUES) values ('SHARE',' ','TESTTREE','01-JAN-00','LEVEL 2',2,'N');

REM INSERTING into PSTREENODE
Insert into PSTREENODE (SETID,SETCNTRLVALUE,TREE_NAME,EFFDT,TREE_NODE_NUM,TREE_NODE,TREE_BRANCH,TREE_NODE_NUM_END,TREE_LEVEL_NUM,TREE_NODE_TYPE,
PARENT_NODE_NUM,PARENT_NODE_NAME,OLD_TREE_NODE_NUM,NODECOL_IMAGE,NODEEXP_IMAGE)
values
('SHARE',' ','TESTTREE','01-JAN-00',1,'TESTING',' ',2000000000,1,'G',
0,' ','N',' ',' ');
Insert into PSTREENODE (SETID,SETCNTRLVALUE,TREE_NAME,EFFDT,TREE_NODE_NUM,TREE_NODE,TREE_BRANCH,TREE_NODE_NUM_END,TREE_LEVEL_NUM,TREE_NODE_TYPE,
PARENT_NODE_NUM,PARENT_NODE_NAME,OLD_TREE_NODE_NUM,NODECOL_IMAGE,NODEEXP_IMAGE)
values ('SHARE',' ','TESTTREE','01-JAN-00',1000000000,'TESTNODE1',' ',2000000000,2,'G',
1,'TESTING','N',' ',' ');

REM INSERTING into PSTREELEAF
Insert into PSTREELEAF (SETID,SETCNTRLVALUE,TREE_NAME,EFFDT,TREE_NODE_NUM,RANGE_FROM,RANGE_TO,TREE_BRANCH,DYNAMIC_RANGE,OLD_TREE_NODE_NUM,LEAF_IMAGE)
values ('SHARE',' ','TESTTREE','01-JAN-00',1000000000,'US001','US001',' ','N','N',' ');

REM INSERTING into PSTREEPROMPT
Insert into PSTREEPROMPT (SETID,SETCNTRLVALUE,TREE_NAME,EFFDT,TREE_BRANCH) values ('SHARE',' ','TESTTREE','01-JAN-00',' ');

 

select * from ALL_TAB_COLUMNS where table_name = 'PS_VOUCHER'