随笔分类 - peoplesoft
流程审批节点审批信息
摘要:SELECT H.TRANSACTION_NBR 流程单号, H.TITLE 流程名称, C.EOAWDTTM_MODIFIED 流程提交时间, L.EMPLID 离职员工ID, L.NAME 离职员工姓名, S.EOAWSTEP_STATUS 节点状态, UL.DESCR 审批节点, US.OPR
阅读全文
PeopleSoft网关
摘要:网关是PS网络代理接收和发送请求,一般PS web的前端是nginx,用户浏览器访问nginx地址,根据请求地址的业务nginx转发到不同的web端口服务 网关这里URL应该配置nginx的内网IP,然后nginx必须配置这个ip对应的监听端口,然后转发到物理网关即PS的web端口 nginx 必须
阅读全文
Nigx配置
摘要:events { use epoll; worker_connections 65535;} 定义了 Nginx 处理客户端连接的事件模型和单进程最大并发连接数,是 Nginx 高并发优化的基础配置,专门作用于events块,worker_connections是每个工作进程能处理的最大并发连接数,
阅读全文
查询应页面的权限
摘要:authorizedactions8 更正4 更新/全部显示2 更新/显示1 添加 displayonly1 只显示0 可编辑 许可权列表页面权限: SELECT OU.CLASSID AS 许可权列表, MI.ITEMLABEL as 组件, CO.ITEMLABEL as 页面,case OU.
阅读全文
posted @ 2020-06-15 18:59
记得承诺过
子节点,子部门的写法
摘要:这里用到了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...
阅读全文
浙公网安备 33010602011771号