GPS_ATSTF_SEQDefault Value: OPR_DEF_TBL_HR.SETID
C=Perform Custom Process
E=Automatic Staffing for All
Default Value: %date
F=Closed
I=Initiated
P=Assignments in Progress
Default Value: I
Prompt Table: PSOPRDEFN_VW
GPS_ATSCP_SRCH(SQL View) |
Index Back |
|---|---|
auto-staffing result searchauto-staffing result search record. |
| SELECT tbl.GPS_ATSTF_SEQ ,tbl.SETID ,tbl.GPS_ATSTF_TYPE ,tbl.RUNDATE ,tbl.GPS_ATSTF_STATUS ,'GPS_ATSTF_AP' AS run_cntl_id ,tbl.oprid FROM %Table(gps_atstf_tbl) tbl ,%Table(gps_atstf_ctrl) ctrl WHERE ctrl.gps_atstf_seq =ctrl.gps_atstf_seq AND tbl.gps_atstf_type = 'C' AND TBL.GPS_ATSTF_STATUS <> 'I' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPS_ATSTF_SEQ |
Number(10,0) | DECIMAL(10) NOT NULL | Auto-Staffing Sequence |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID |
| 3 | GPS_ATSTF_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Process Type
C=Perform Custom Process E=Automatic Staffing for All |
| 4 | RUNDATE | Date(10) | DATE |
Process Scheduler Run Date
Default Value: %date |
| 5 | GPS_ATSTF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Current Status
F=Closed I=Initiated P=Assignments in Progress Default Value: I |
| 6 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN_VW |