GP_PSLP_ASTSRCH(SQL View) |
Index Back |
---|---|
Payslip Assignmnt Set Upd SrchThis is a Update search record for the Assignment Set component |
SELECT OP.OPRID , GP_CNTRY_PSLP_ASET , GP_PSLP_ASGN_SET , DESCR FROM PS_GP_PSLP_ASGN_ST A , PS_GP_OPR_RULE_PRF OP WHERE (A.GP_CNTRY_PSLP_ASET = 'ALL' OR (A.GP_CNTRY_PSLP_ASET <> 'ALL' AND OP.COUNTRY = 'ALL') OR (A.GP_CNTRY_PSLP_ASET <> 'ALL' AND A.GP_CNTRY_PSLP_ASET = OP.COUNTRY)) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). | |
2 | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: %EDITTABLE |
|
3 | Character(12) | VARCHAR2(12) NOT NULL | Assignment Set | |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |