TL_RAPD_UPDT_VW(SQL View) |
Index Back |
---|---|
T&L Rapid Update view |
SELECT ST_INSTANCE , DESCR , RAPID_UPDATE_FLAG FROM PS_TL_RAPID_HEADER WHERE RAPID_UPDATE_FLAG IN ('0','3') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | ST_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Session Number |
2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
3 | RAPID_UPDATE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Session Status
0=Not Submitted 1=Submitted to Reported Time 2=Submitted to Time Administrati 3=Need to Resubmit the Session |