CNAO_XML_JNLCTG(SQL View) |
Index Back |
|---|
| SELECT PM.OPRID , PM.RUN_CNTL_ID , PM.BUSINESS_UNIT , JC.JRNL_CTG_ID ,JC.JRNL_CTG_NM ,JC.JRNL_CTG_SHORT_NM FROM PS_CNAO_XMLG_PARM PM , PS_CNAO_JRNL_CTG JC , PS_SET_CNTRL_REC SC WHERE PM.BUSINESS_UNIT=SC.SETCNTRLVALUE AND SC.RECNAME='CNAO_JRNL_CTG' AND SC.SETID=JC.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | JRNL_CTG_ID | Character(60) | VARCHAR2(60) NOT NULL | Journal Category ID |
| 5 | JRNL_CTG_NM | Character(60) | VARCHAR2(60) NOT NULL | Journal Category Name |
| 6 | JRNL_CTG_SHORT_NM | Character(1) | VARCHAR2(1) NOT NULL | Journal Category Short Name |