随笔分类 - peoplesoft
查询应页面的权限
摘要:authorizedactions8 更正4 更新/全部显示2 更新/显示1 添加 displayonly1 只显示0 可编辑 许可权列表页面权限: SELECT OU.CLASSID AS 许可权列表, MI.ITEMLABEL as 组件, CO.ITEMLABEL as 页面,case OU.
阅读全文
子节点,子部门的写法
摘要:这里用到了Oracle的一个树形结构查询函数select * from record START WITH A.TREE_NODE IN ('COST_CTR_10053')CONNECT BY PRIOR A.TREE_NODE_NUM = A.PARENT_NODE_NUM.查出指定节点下的所以
阅读全文
peoplesoft SQR language
摘要:Understanding SQR Data Elements !Variables!Variables are storage places for text or numbers that you define and manipulate.!• $ begins a text or date
阅读全文
PeopleSoft Home Subdirectories
摘要:PeopleSoft Home Subdirectoriesappserv — home to the Application Server and Process Scheduler Server; location of psadmin where you start, stop, and ma...
阅读全文
People Tools catalog tables.
摘要:People Tools catalog tables.ProjectsPSPROJECTDEFN — Project header tablePSPROJECTITEM — Definitions in the projectFieldsPSDBFIELD — Fields in the syst...
阅读全文
Debugging of a SQR program
摘要:Debugging of a SQR program can be done in many ways. They are·Using SHOW /DISPLAY command·Using Compiler directives·Using command line FLAGSSHOW /DISP...
阅读全文