HCSC_CLK_PRCS_IDPrompt Table:
HCSC_CLK_PRODVW
Set Control Field: HCSC_CLK_PROD_ID
Prompt Table: HCSC_CLK_CNTPVW
HCSC_CLK_PID_VW(SQL View) |
Index Back |
|---|---|
HCSC_CLK_PID_VWUsed as Prompt Table by HCSC_CLK_EVPRPH (Record) HCSC_CLK_PRCS_ID (Field) |
| SELECT HCSC_CLK_PRCS_ID ,HCSC_CLK_PROD_ID , COUNTRY , DESCR40 FROM PS_HCSC_CLK_PRCPHS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_CLK_PRCS_ID |
Character(20) | VARCHAR2(20) NOT NULL | Process Lockdown Process ID |
| 2 | HCSC_CLK_PROD_ID | Character(4) | VARCHAR2(4) NOT NULL |
Product owner ID
Prompt Table:
HCSC_CLK_PRODVW
|
| 3 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: HCSC_CLK_CNTPVW |
| 4 | DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |