PROCESS_INSTANCEU=Validate and Upload
V=Validate Only
S=HR System Photos
U=User Photos
C=Complete
V=Void
X=W-2c Issued
Y/N Table Edit
HR_PH_RESIZ_AET(SQL Table) |
Index Back |
|---|---|
Employee Photo ResizeState record for HR_EMPLPHOTO AE process |
| # | 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 | CHUNKSIZE | Number(10,0) | DECIMAL(10) NOT NULL | Chunk Size |
| 5 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 6 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 7 | HMCR_UUID | Character(30) | VARCHAR2(30) NOT NULL | UUID |
| 8 | HR_UPLOADFILE | Character(1) | VARCHAR2(1) NOT NULL | Upload from file |
| 9 | HR_VAL_UPLOAD | Character(1) | VARCHAR2(1) NOT NULL |
Upload Options
U=Validate and Upload V=Validate Only |
| 10 | HR_PHOTO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Photo Type
S=HR System Photos U=User Photos |
| 11 | HR_SOURCEDIR | Character(30) | VARCHAR2(30) NOT NULL | Source Directory |
| 12 | HR_WORKINGDIR | Character(30) | VARCHAR2(30) NOT NULL | Working Directory |
| 13 | HR_OVERWRITE | Character(1) | VARCHAR2(1) NOT NULL | Overwrite Existing Photos |
| 14 | PROCESS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Process Flag
C=Complete V=Void X=W-2c Issued Y/N Table Edit |
| 15 | SQL_ID1 | Character(30) | VARCHAR2(30) NOT NULL | TL |
| 16 | SQL_ID2 | Character(30) | VARCHAR2(30) NOT NULL | TL |