MIL_PROC_DEFN(SQL Table) |
Index Back |
|---|---|
Military Pocessing DefinitionThis record is used to turn on approvals, allow prenotificaiton, and to set access method which will be used to determine unit commander. There should be only one row in this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Access Type
1=By Dept Security Tree 2=By Supervisor ID 3=By Department Manager ID 4=By Reports To Position 5=By Part Posn Mgmt Supervisor 6=By Part Posn Mgmt Dept Mgr ID 7=By Group ID Default Value: 3 |
| 2 | APPROVAL_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
N=No Approval Required Y=Approval Required Default Value: Y |
| 3 | PTAFPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL |
Approval Process ID
Prompt Table: PTAFAW_TXN |
| 4 | MIL_ALLOW_PRENOTIF | Character(1) | VARCHAR2(1) NOT NULL |
Allow Prenotification Flag
N=No Prenotification Y=Prenotificaiton Allowed Y/N Table Edit Default Value: N |