GRP_AP_DEL_VW(SQL View) |
Index Back |
|---|---|
Control Group Delete View |
| select business_unit, grp_ap_id, group_dt, grp_ap_status, ctl_gross_amt, ctl_vouchers, assigned_by_oprid, assigned_to_oprid, dttm_assigned, dttm_due, dttm_complete from PS_GRP_AP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_AP_NONVW |
| 2 | GRP_AP_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Control Group ID
Default Value: NEXT Prompt Table: GRP_AP |
| 3 | GROUP_DT | Date(10) | DATE |
Group Control Date
Default Value: %date |
| 4 | GRP_AP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status of Control Group
A=Assigned E=Entry Set Aside O=Open R=Ready for Review S=Supervisor Set Aside V=Verified Default Value: O |
| 5 | CTL_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Control Gross Amount |
| 6 | CTL_VOUCHERS | Number(6,0) | INTEGER NOT NULL | Control Voucher Number |
| 7 | ASSIGNED_BY_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Group Assigned by |
| 8 | ASSIGNED_TO_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Assigned to
Prompt Table: OPR_AP_VW |
| 9 | DTTM_ASSIGNED | DateTime(26) | TIMESTAMP | Date/Time Assigned |
| 10 | DTTM_DUE | DateTime(26) | TIMESTAMP | Date/Time Due |
| 11 | DTTM_COMPLETE | DateTime(26) | TIMESTAMP | Date/Time Completed |