PYCYCL_REQ_VW(SQL View) |
Index Back |
---|---|
Pay Cycle Cash Required VW |
select distinct a.business_unit, a.pay_cycle from PS_PYMNT_VCHR_XREF a where a.pymnt_selct_status = 'R' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | PAY_CYCLE | Character(6) | VARCHAR2(6) NOT NULL |
Pay Cycle
Prompt Table: SP_PYCYCL_NONVW |