PROCESS_INSTANCEPrompt Table: GROUP_TYPE_TBL
EFFDTDefault Value: %date
A=Available for Posting
D=Do Not Post
N=Posted
W=Waiting for Approval
SSF_GRPAPPR_AET(SQL Table) |
Index Back |
|---|---|
Group Approval |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | GROUP_ID_SF | Character(15) | VARCHAR2(15) NOT NULL | Group ID |
| 6 | GROUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Group Type
Prompt Table: GROUP_TYPE_TBL |
| 7 | ORIGIN_ID | Character(5) | VARCHAR2(5) NOT NULL | Origin ID |
| 8 | CONTROL_AMT | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Control Total |
| 9 | CONTROL_CNT | Number(10,0) | DECIMAL(10) NOT NULL | Control Count |
| 10 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 11 | SF_DATETIME | DateTime(26) | TIMESTAMP | SF DateTime |
| 12 | POST_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Posting Action
A=Available for Posting D=Do Not Post N=Posted W=Waiting for Approval |