BCNAMEBCSCROLLBCITEMPARENTRB_CLONE_REC_VW(SQL View) |
Index Back |
|---|---|
Clone RecordsShows all the records which can be cloned as per the CI information. |
| SELECT A.BCNAME , A.BCSCROLL , A.BCITEMPARENT , B.RECNAME , A.PARENTRECNAME , A.PROMPTED , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , MIN(B.SEQUENCE_NBR_6) , MAX(B.SEQUENCE_NBR_6) FROM PS_RB_CLONE_REC A , PS_RB_CLONE_FLDS B , PSRECDEFN C WHERE A.BCNAME = B.BCNAME AND A.BCSCROLL = B.BCSCROLL AND A.BCITEMPARENT = B.BCITEMPARENT AND B.INCLUDE = 'Y' AND A.BCSCROLL > 0 AND B.RECNAME = C.RECNAME AND C.RECTYPE IN (0,1) GROUP BY A.BCNAME, A.BCSCROLL, A.BCITEMPARENT, B.RECNAME, A.PARENTRECNAME, A.PROMPTED, A.MESSAGE_SET_NBR, A.MESSAGE_NBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BCNAME |
Character(30) | VARCHAR2(30) NOT NULL | Business Component Name (see PSBCDEFN). |
| 2 | BCSCROLL |
Number(3,0) | SMALLINT NOT NULL | Scroll level |
| 3 | BCITEMPARENT |
Character(30) | VARCHAR2(30) NOT NULL | Parent Collection Name |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 5 | PARENTRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Parent Record Name |
| 6 | PROMPTED | Character(1) | VARCHAR2(1) NOT NULL | Prompted? |
| 7 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 8 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 9 | MIN_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Minimum Sequence Number |
| 10 | MAX_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Maximum Sequence Number |