PC_CR_PRL_VW

(SQL View)
 Index Back

Custom Rate Prompt for PRL


SELECT SETID , RATE_NAME , DESCR FROM PS_PC_CRATE_DEFN WHERE APPLY_RATE_TO = 'Q' AND FIELDNAME1 IN (' ', 'EMPLID', 'JOBCODE', 'PROJ_ROLE', 'REGION_CD') AND FIELDNAME2 IN (' ', 'EMPLID', 'JOBCODE', 'PROJ_ROLE', 'REGION_CD') AND FIELDNAME3 IN (' ', 'EMPLID', 'JOBCODE', 'PROJ_ROLE', 'REGION_CD') AND FIELDNAME4 IN (' ', 'EMPLID', 'JOBCODE', 'PROJ_ROLE', 'REGION_CD') AND FIELDNAME5 IN (' ', 'EMPLID', 'JOBCODE', 'PROJ_ROLE', 'REGION_CD')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

Prompt Table: SP_SETID_NONVW

2 RATE_NAME Character(15) VARCHAR2(15) NOT NULL Unique Identifier for a Custom Rate Name
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description