EPS_ORG_PARMS(SQL Table) |
Index Back |
|---|---|
Run Control EPS Assign OrgThis record contains the parameters for the EPS Asign Organization Process. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 4 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 5 | ZIP_SELECTION_EPS | Character(1) | VARCHAR2(1) NOT NULL |
Postal Selection
B=Begins With E=Equals To N=Not Applicable R=Range Default Value: N |
| 6 | ZIP_FROM_EPS | Character(5) | VARCHAR2(5) NOT NULL | Postal Code |
| 7 | ZIP_TO_EPS | Character(5) | VARCHAR2(5) NOT NULL | Postal Code |
| 8 | ASN_ORG_IND_EPS | Character(1) | VARCHAR2(1) NOT NULL |
EPS Assign Organization Ind
Y/N Table Edit |
| 9 | ACTION_ORG_EPS | Character(1) | VARCHAR2(1) NOT NULL |
EPS Code Typ Org Action
R=Replace S=Skip Default Value: S |
| 10 | EXT_ORG_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Organization Type
Prompt Table: SCC_ORG_TYP_TBL |
| 11 | LS_SCHOOL_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
School Type
Prompt Table: LS_SCHL_TYP_TBL |
| 12 | ASN_LOD_CD_TYP_EPS | Character(10) | VARCHAR2(10) NOT NULL |
EPS Code Type
Prompt Table: EXORGCDTYPE_VW |
| 13 | ASN_DEL_CD_TYP_EPS | Character(10) | VARCHAR2(10) NOT NULL |
EPS Delete Data Type
Prompt Table: EXORGCDTYPE_VW |
| 14 | ASN_DEL_IND_EPS | Character(1) | VARCHAR2(1) NOT NULL |
Delete EPS Data Type
Y/N Table Edit Default Value: N |
| 15 | ASN_LOD_IND_EPS | Character(1) | VARCHAR2(1) NOT NULL |
Assign EPS Data Type
Y/N Table Edit Default Value: N |