RUN_IDHPYP_STG_NA_VW(SQL View) |
Index Back |
|---|---|
Pay Run Id PromptPay Run Id Prompt |
| SELECT DISTINCT a.run_id ,a.descr FROM PS_PAY_RUN_TBL a ,PS_GL_GEN_HISTORY b WHERE a.run_id = b.run_id AND PROGRAM_ID IN ( SELECT PROCESS_NAME FROM PS_EO_MSGBATPRM WHERE PROCESS_NAME = 'PAYGL01' AND PROCESS_STATUS = 'N') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Pay Run ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |