CFSTEPS_VW(SQL View) |
Index Back |
---|---|
CF Configuration Result StepsList of steps needed for the actions taken to complete the cinfiguration process. |
SELECT A.CF_PROJECT , A.SEQUENCE_NBR_6B , A.CF_STEP_NBR , B.CF_STEP , A.CF_STEP_REQD_FLG FROM PS_CFMANUAL_STEPS A , PS_CF_CONFIG_STEPS B WHERE A.SEQUENCE_NBR_6B > 9 AND B.SEQUENCE_NBR_6B = A.SEQUENCE_NBR_6B |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CF_PROJECT | Character(15) | VARCHAR2(15) NOT NULL | CF Configuration ID |
2 | SEQUENCE_NBR_6B | Number(6,0) | INTEGER NOT NULL |
Sequence B
Default Value: 1 |
3 | CF_STEP_NBR | Number(6,0) | INTEGER NOT NULL | Step Number |
4 | CF_STEP | Character(50) | VARCHAR2(50) NOT NULL | Chartfield Step |
5 | CF_STEP_REQD_FLG | Character(1) | VARCHAR2(1) NOT NULL | ChartField Step Required |