BPW_RCREC_S_VW(SQL View) |
Index Back |
|---|
| SELECT BPW_TASK_ID ,RECNAME , BPW_SYS_DEFN_FLG FROM PS_BPW_TSK_RC_RECS WHERE BPW_SYS_DEFN_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Task ID | |
| 2 | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN |
|
| 3 | BPW_SYS_DEFN_FLG | Character(1) | VARCHAR2(1) NOT NULL | System Defined |